Formatting worksheets

E

Eric

I have multiple worksheets. The number of columns of data
on each varies. (I have a variable which of the number of
columns)

I want to make the following changes to each sheet:

1. The first 2 rows are to be made bold

2. The first column is to be 24 wide

3.
 
F

Frank Kabel

Hi
try the following:
- first group the sheets (hold down the SHIFT key while selecting the
sheets)
- apply your format
- ungroup the sheets
 
P

poppy

Hi Eric

Do exactly what Frank said except that you must now go to the Tool
menu and select Record Macro while doing these steps. The macro wil
write the code for you in VBA

Hope this is what you are looking for.



Kind Regard
 
Top