Suggestions or Advice applying a macro to multiple worksheets

[dshanman]

Hello again. I have a macro for copying a formula to X number of rows. I am going to need to apply this macro to 21 worksheets. I have found 2 ways of doing this that "work". The first one uses this macro:

Please Login or Register  to view this content.

While this runs smoothly, it is limiting because ideally I will only want to apply this to 21 of 63 worksheets in my workbook.

The second version uses an array and I know I can specify which sheets to apply it to, but Excel freezes when I run it:

Please Login or Register  to view this content.

I don't know if this is a limitation of my computer, the macro, both, or something else. If anybody has a simpler way to get this formula to only apply to specific worksheets, I would greatly appreciate it!

Thanks

[vandan_tanna]

I think the problem with your second macro is the "for each c" part. That part makes you go through each cell of A1:A1000 and repeat the copy paste operation 1000 times!

I cana thin kof two easy solutions
1, replace your for each c ... next c part with (UNTESTED)

Please Login or Register  to view this content.

or

2. Use flag on the sheet to decide

Please Login or Register  to view this content.

Hopefully one of these works for you

[JBeaucaire]

Since you're using sequentially named sheets as your desired targets, you can use this syntax, too:

Please Login or Register  to view this content.