Macros not recording properly

T

Trish

I have a spreadsheet that I want to format the same way
each week. It's an export from Access. I recorded the
macro but when I play it back some of the formatting from
worksheet 1 appear on worksheet 2. I don't know why it's
doing this. Is there a way to get around it without
creating one macro per worksheet?

Thanks,
Trish
 
A

AlfD

Hi!

I'm sure someone can help.

Call up the recorded macro. (Alt + F8 or tools > macro> macros)
Choose edit
Copy the contents of the macro and post them here.

At the same time tell us what your workbook structure is (worksheets
and what you are trying to achieve.

Al
 
Top