$$Excel-Macros$$ Re: change from small letter to capital

2008-09-20 Thread Manish Purohit
Use UPPER(Cell reference). From: excel-macros@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of vinay keni Sent: Saturday, September 20, 2008 5:22 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ change from small letter to capital dear all, i want to know

$$Excel-Macros$$ HOW TO CALCUATE THE NO. OF YEARS BETWEEN TWO DATES

2008-09-20 Thread vivek jain
Dear All, I am preparing a fixed asset register for the last fifty years for an organization. I have to calculate the depreciation based on the no. of years an asset has been used. I have to calculate depreication upto 31/03/2004 and then for the f.y. 2004-05. Now I have to calculate the no. of

$$Excel-Macros$$ Re: Excel Macros Book?

2008-09-20 Thread [EMAIL PROTECTED]
Totally agree with Mohd. I have several books (learning as well) and Microsoft Press Step-by- Step is one of the best Robert On Sep 17, 6:14 am, "Idrees Akhtar" <[EMAIL PROTECTED]> wrote: > VBA Programmer Refrence 2003 is the one of the best book to learn the vba > programming in EXCEL. > > YOu

$$Excel-Macros$$ change from small letter to capital

2008-09-20 Thread vinay keni
dear all, i want to know how to change from small letters to capital letters as i have some 500 persons name which i have typed in small letters now wants to change those things in the Big letters . reply fast its urgent -- Regards, Vinay Keni --~--~-~--~~~