Macros not recording properly

  • Thread starter Thread starter Trish
  • Start date Start date
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
 
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
 
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

Excel 2003 - assign macro to custom toolbar button 1
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
sending a macro to another person 1
Worksheet macro conditional format question 3
macro help 2
Macro for individuals worksheets 2
Protecting a macro 4
Multiple Workbooks using same macro 4

Back
Top