Pasting formulas over to multiple sheets at once

[luv2glyd]

I have a master formula sheet and 1000 additional sheets where formulas from master have to be pasted. Just looking for the most efficient way of doing this as the formulas are rather bulky.
Trying to select all 1000 sheets at once and THEN copy over formulas like this, without including the last line in the loop, but getting an error on the last line:

Please Login or Register  to view this content.

If I include last line in the loop, it takes about 40 seconds to do the whole procedure...

Alternatively I tried using the copy command, but getting an error on the second to last line:

Please Login or Register  to view this content.

Would love to get it to work both ways and try running it to see which is faster. I did try both ways by copying to each sheet one at a time using the loop, but it takes way too long, thus attempting to select all sheets first and THEN transfer the formulas.

Thank you.

[FDibbins]

1st, if you have 1000 sheets - wow!!! that is probably 990 sheets too many, how on earth do you find anything?

2nd, if you need to copy the same formula to the same cell in a range of sheets, try this apprpoach...
1. Copy the formula you want
2. click the 1st sheet you want to include
3. SCROLL to the last sheet you want to include
4. hold down the shift key and click on that last sheet. You should now have GROUPED all those sheets - what you do to 1, will be done to them all
5. paste the formula to where you want it to go. This should paste it through to all the selected sheets
6. Nake sure you unGROUP all sheets when done by either clicking on an unselected sheet or right-clicking a sheet tab and selecting UNgroup

[luv2glyd]

Hi Ford,

Thanks for your post. What you described was actually exactly the original way I did it, but the issue is that the 1000 sheets change names all the time (and the macro records all individual sheet names), that's why I have to do the selection using a loop. Also, I almost got the second method in my post above to work (it sometimes works, sometimes does not depending if I manually select one of the 1000 sheets or not) and it is actually trims more than 50% off of the time vs. the original way (one you described).

[FDibbins]

Why on earth do you have 1000 sheets though?

[luv2glyd]

Historical options data - 1 for each symbol.