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