Pasting a formula through multiple worksheets

[lukerees83]

I have a formula that I want to insert into the same cell on every sheet in my workbook (Excel Mac 2011).

In theory, shouldn't I first highlight all the worksheet tabs at the bottom, then paste the formula into one of the appropriate cells on any sheet? Shouldn't I then find that it has been pasted throughout them all?

This is what I have tried and it has not worked, when I'm sure I have done it before (maybe on a different version). Is there something I need to change in my settings to make sure it does this as I want?

 

[lukerees83]

Additional: I have just noticed that when I copied the original formula at the time I had all the tabs in the source workbook highlighted too. Could this have confused excel as to what instruction to use?

If I un-highlight all the tabs, then just click on one source cell containing the formula then paste it through the destination worksheets as described above, should this do the trick?

 

[Sektor]

First, you should copy cell with formula, then select sheets and paste this formula.

 

[rs2k]

Would this work for you? I've used B2 for the formula;

Sub InsertFormula()
Dim wSheet As Worksheet
For Each wSheet In Worksheets
    wSheet.Range("B2").Formula = "=NOW()" 'add your formula
    
 Next wSheet
 
End Sub

HTH
Colin