Macro to change all the font across all the entier workbook to one style

[Cupragsw]

Hello chaps

What i am wanting is a code to place inside my macro to change allt he font to Arial 11 on every single colloum of every single page i have 8.

I need this as currently that data we recevie comes across from diffrent sources before i filter it in to diffrent sheets with my macro

i am assuming this is easily done

without manually doing it

its on excel 2003

[ranman256]

Please Login or Register  to view this content.

[6StringJazzer]

ranman256's code will work for either the active sheet, or the sheet containing the code. The code below will work for all sheets. Also I recommend against using Select.

Please Login or Register  to view this content.