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
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
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
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
--~--~-~--~~~