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:
If I include last line in the loop, it takes about 40 seconds to do the whole procedure...For i = 3 To 1002 Worksheets(i).Select (False) Next i Sheets.Range("H101:T200").Formula = Sheets("Master Formulas").Range("H101:T200").Formula
Alternatively I tried using the copy command, but getting an error on the second to last line:
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.Sheets("Master Formulas").Range("H101:T200").Copy For i = 3 To 1002 Worksheets(i).Select (False) Next i Sheets("A123").Range("H101").Select 'attempting to select a cell where to paste to here Selection.PasteSpecial Paste:=xlPasteFormulas
Thank you.
Bookmarks