upper to lower case

[stevekirk]

hi,

i have several worksheets that have some uppper and some lower case words
i would like to make them all one ( lower)
could you please help me with this

thanks
steve

[Leith Ross]

Hello Steve,

Here is macro to convert every cell to lower case.

Please Login or Register  to view this content.

Sincerely,
Leith Ross

[stevekirk]

hi leith,

thanks but i am getting an error on

Please Login or Register  to view this content.

will this do all sheets in the workbook in one go

thanks
steve

[jindon]

try

Please Login or Register  to view this content.

[Leith Ross]

Hello Steve,

I am running Excel 2003. The code works without error on my machine. What version of Excel are you using?

Sincerely,
Leith Ross

[stevekirk]

thanks jindon

that does change to lower case - but can it be modified so it does all the sheets at the same time

leith - i think its 2002

steve

[jindon]

thanks jindon

that does change to lower case - but can it be modified so it does all the sheets at the same time

leith - i think its 2002

steve

Please Login or Register  to view this content.