Please help me out.
On Tue, Jun 21, 2011 at 10:09 AM, Subhash Yadav wrote:
> Dear Experts,
>
> Please refer my attached file for which i want solution.
>
> My queries are:
>
> 1. In the "type" column - Value is "previous type+50". but if the values
> are 300,550,800,1050,1300,1550 etc this st
Please help me out.
Regards,
Subhash Yadav
On Wed, Jun 22, 2011 at 2:11 PM, Subhash Yadav wrote:
> No, this is daily entry sheet for fuel issued to equipments. This will
> continue for years.
>
>
> Regards,
>
>
> Subhash Yadav
>
> On Wed, Jun 22, 2011 at 6:16 AM, ashish koul wrote:
>
>> @IC
Dear All,
I want any VBA code or some tool to Unprotect Sheet in Excel 2007
I forgot the password..
*Best Regards,*
*Venkat*
*
*
*
*
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tri
Hi,
any body help me , for prepare single pivot from more than one
worksheet.
regrds
deepak
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceld
Use a public variable like this
Public Flg as boolean
in the workbook open even set the variable to false
Flg=False
Hv a toggle button on the worksheet
which will set the Flg value to True and False alternatively when you
press the button. when
the flg is true, function will work else it will n
I have a file that has, in the third row, cashflows on which interest
is to be accrued (in this case, compounded at 10% per period). I am
trying to show the cumulative value of those cashflows plus accrued
interest, calculated in a single row. So, for example, in 7th period
the formula I came up wi
Suppose there are fields like: Name, Commision, Email Id etc in Sheet1
Now Data contained is given below
Name CommissionEmail
ABC 1000 a...@abc.com
DEF500d...@abc.com
ABC 700 a...@abc.com
ABC800 a...
Suppose there are fields like: Name, Commision, Email Id etc in Sheet1
Now Data contained is given below
Name CommissionEmail
ABC 1000 a...@abc.com
DEF500d...@abc.com
ABC 700 a...@abc.com
ABC800 a...
You need some Variables (memory variable)
http://www.excel-vba.com/excel-vba-contents.htm
Sub Test()
'--declaring variable
Dim MyCell As Range
Dim MyValue As Variant
Dim CompareResult as Boolean
'--assignments
Set MyCell = Range("A1")
MyValue = MyCell.Value
'--copying the value to another
try this
set sheet calculation to manual
'application.Calculation=xlCalculationManual (VBA)
sheet calculates only when the user presses the Shift + F9 button.
On Mon, Jun 27, 2011 at 6:08 PM, crossy75 wrote:
> I have this bit of code in a spreadsheet - it is used with a formula
> to coun
Hi
Give below is the code I used to send email and attache attachement to
the same email. Only success I had till now is in sending email and
attaching same sheet as attachement. I am not able to attache a pdf
and send it through email.
Can some one please advsie me how can I attache a pdf file a
Try removing Application.Volatile
On Jun 27, 5:38 pm, crossy75 wrote:
> I have this bit of code in a spreadsheet - it is used with a formula
> to count the number of visible rows. This is useful in accounts where
> people hid things thus counting what you see isnt always what you get!
>
> 'Functi
I am new to VBA and would like to ask everyone a question about how to
capture an object?
I want to copy a value and position in excel. For example:
1 - Find cell A1 and get the contents, "code1234" and remember that
position
2 - I want to copy the contents to cell T4
3 - Go back to cell positio
I have this bit of code in a spreadsheet - it is used with a formula
to count the number of visible rows. This is useful in accounts where
people hid things thus counting what you see isnt always what you get!
'Function Vis(Rin As Range) As Range
'Returns the subset of Rin that is visible
did u try
Range("A1048576").end(xlup).row '-- to get the last populated row in column A
On Mon, Jun 27, 2011 at 3:58 PM, Jorge Marques wrote:
>
> Hi guys i need your expertise, i have this macro and i need your advise, i
> just need to format the excel like i put in the example to format the
Hi guys i need your expertise, i have this macro and i need your advise, i
just need to format the excel like i put in the example to format the cells
with line upperlines around all data and only in the cells filled in column
A. this is my code so far, i know to macro it, but the format of table k
Hi,
I am trying to make bullet chart using
http://peltiertech.com/WordPress/how-to-make-horizontal-bullet-graphs-in-excel/.
But I am not getting output as in the link.
Please let me know whats the problem in the chart. Thanks!
--
--
I did as per insturction still I can able to access button. Please can u
send the file. Thanks!
On Fri, Jun 24, 2011 at 9:38 PM, GoldenLance wrote:
> I am blocked from attaching a file I guess. Not sure why.
>
> So here's how you do it.
>
> 1. Hold CTRL and right-click on the button shape as wel
Thanks!
On Fri, Jun 24, 2011 at 9:38 PM, GoldenLance wrote:
> I am blocked from attaching a file I guess. Not sure why.
>
> So here's how you do it.
>
> 1. Hold CTRL and right-click on the button shape as well as the chart.
> Go to format and properties, and then uncheck the lock
> 2. After dese
19 matches
Mail list logo
