Recursive formula for all Tabs

[zeph2323]

Hello!,

I have what should be a quick solution. I want to perform this Macro for all tabs in my workbook :

Columns("M:M").Select
Selection.NumberFormat = "0.00_);[Red](0.00)"

how would i do this?

Thanks in advance!!

[BigBas]

Try

Please Login or Register  to view this content.

[zeph2323]

Awesome thanks!!! Works Perfect !! =)

[shg]

If you ever decide to add a chart sheet to your workbook, you'll want a slight change:

Please Login or Register  to view this content.