Re: $$Excel-Macros$$ Converting Text Case By VBA

2011-07-07 Thread ankur
*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),

Re: $$Excel-Macros$$ Converting Text Case By VBA

2011-07-06 Thread 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