ALLCAPS to Initial Caps in cells using VBA

[pendle666]

Hello

I'm using Excel 2007 SP3.

I have a spreadsheet with columsn written in all capitals and I'd like to change them to Initial Capitals.

I already have a macro that I'm using working with this spreadsheet and I'd like to incorporate the change in that.

regards

Pendle

 

[PHV]

I'd use the StrConv function with vbProperCase.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[pendle666]

Excellent - thank you