search all numbers in a sheet and change to dollars ($)

[k1dr0ck]

Hi,

my code does not work trying to search all the numbers or values that looks like a number even if not formatted as a number in a sheet and change the format to dollars ($)
would like it to also be applicable to other excel files when i export it

Please Login or Register  to view this content.

[NeedForExcel]

Try this

Please Login or Register  to view this content.

[k1dr0ck]

Thanks NeedForExcel!

Works Great!

Just a quick question what does the ".SpecialCells(xlLastCell)" mean?

[NeedForExcel]

Hi,

Its a way of finding out the last utilized cell, so that we can make the loop run only till there..

[k1dr0ck]

I see, thanks again