Writing macro to format multiple worksheets?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Beginner in Macros, willing to learn a lot in short amount of time.

I am in need of information on how to write a macro that will format the
spreadsheets across multiple worksheets? [vs only working cell specific]
 
Unless you want to specifically write a Macro select the 1st sheet then,
with the Shift key pressed, select the last sheet. Now anything that you do
on onesheet you will be doing on all sheets. To Ungroup the sheet
right-click on a sheet tab and select Ungroup Sheets.

If you do want a Macro then use the Macro Recorder as a basis and then alter
the code.

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk
 
Back
Top