Apply Macro to specific worksheets in workbook

Hi everyone,

I have a different question regarding this macro in another post, so I figured I'd put in a separate post for it. I have the following macro:

Please Login or Register  to view this content.

So right now the macro is run in every single worksheet in the workbook. Unfortunately, it appears the TRIM function erases formulas in cells. I want this macro to apply only to certain worksheets. Say the worksheets i want the macro to run on are named A1-A100. How could I apply this?

Thanks!!

Maybe:

Please Login or Register  to view this content.

Hi John,

Thanks. So Sheets(Range("A" & i).Value).Activate indicates the macro should work on any worksheets that start with an "A"?

So my worksheets are named like this PA (1) PA (2), etc. Does that mean it should be:

For i = 1 To 100
Sheets(Range("PA (" & i).Value).Activate

I may have been mistaken. I assumed when you said "Say the worksheets i want the macro to run on are named A1-A100" you were talking about a range in Column A. This macro gets the values from A1:A100 in Column A?

Modified:

Please Login or Register  to view this content.