*dear friends
plz check the attached file for changing the text case of selected range
*Have A Nice Time Enjoy Life
Regards:
CMA Ankur Pandey
(Someone Different)
I'm not the best but i'm not like the rest~~
On Thu, Jul 7, 2011 at 10:23 AM, anandydr anand...@gmail.com wrote:
Dear STDEV(i),
Converting text case to ProperCase in VBA
alt:
Instead of using Application.Function / WorksheetFunction) we can also use
VBA function:
*StrConv *function
StrConv( , vbProperCase)
Example in sub procedur
Sub ConvertProperCase()
Application.ScreenUpdating = False
Dim Cell As