Formatting worksheets

  • Thread starter Thread starter Eric
  • Start date Start date
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.
 
Hi
try the following:
- first group the sheets (hold down the SHIFT key while selecting the
sheets)
- apply your format
- ungroup the sheets
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Code copies twice...? 13
Copy columns and paste with blank column between 5
append multiple worksheets data into a single multi-dimensional array 4
Excel Columns moving up and down on their own in a worksheet. What Goes? 2
Excel 2013 Merge Data 2
Mid column sum formulas with varied ranges to sum 17
Apply cell formatting using VBA 1
loop to copy paste 5

Back
Top