Apply number formatting to range of data in column across all worksheets

[carlito2002wgn]

Hi,

I have a workbook with several worksheets. I am looking for help with a macro that would loop through all sheets in my workbook and apply number formatting to the entire range of numbers in a specific column.

For example, I want to apply _(* #,##0.00_);_(* (#,##0.00);_(* ""-""??_);_(@_) formatting to column O on all of my worksheets. BUT, the range of data in that column to which I want to apply that formatting has a header, and more data below it that I do not want formatted. In other words, if I were doing it manually, I could select cell O2 then Ctrl + Shift + down arrow, and then apply my formatting.

All help is greatly appreciated!

Carlos

[PCI]

select cell O2 then Ctrl + Shift + down arrow, and then apply my formatting.
Is it for all sheets the range staring at O2 ?
Note: Header does not mind for the number format

[carlito2002wgn]

Hi PCI. Thanks for the quick reply.

Yes, all sheets the range starting at O2.

I need to apply formatting to other columns as well, but I figured that with help doing it for column O, I would be able to do it for the rest of the columns that need formatting (not all same formatting).

Thank you!

[PCI]

See next code

Please Login or Register  to view this content.