Formatting worksheets
 

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.

Formatting worksheets
 

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

--
Regards
Frank Kabel
Frankfurt, Germany


Eric wrote:
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.

Formatting worksheets
 

Frank

Sorry, my post was incomplete. I want to do this using VBA.



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

--
Regards
Frank Kabel
Frankfurt, Germany


Eric wrote:
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.

.

Formatting worksheets
 

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

--
Message posted from http://www.ExcelForum.com