*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 wrote:
> Dear STDEV(i),
>
> As you say te
Dear STDEV(i),
As you say text case can be converted to Proper Case using VBA but
wont be using Application.Function/Worksheet Function give faster
results as compared to this other method?
Warm regards,
Anand Kumar
On Jul 7, 6:02 am, "STDEV(i)" wrote:
> Converting text case to ProperCase in VB
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
