Formatting display properties on all sheets

[AVR]

I have about 10 sheets in my workbook. I want to loop through all the sheets, select all the cells(except first row) and set the font proprties to a specfic value. This is what I have now...

Please Login or Register  to view this content.

The trouble is, the changes take place only on the sheet where I call the macro from.
Also, I am not aware of a way to specify all cells except the first row as I would not know the range in advance.

Please let me know what I am missing.

Thanks !

[VBA Noob]

Hi,

This code takes the range to be the last enter in Col A. You may need to tweak with code from the attached link

http://www.rondebruin.nl/last.htm

Please Login or Register  to view this content.

VBA Noob

[AVR]

Thanks. Your code snippets and the link helped !

[VBA Noob]

Glad it helped

VBA Noob