need help with multiple sheets

[offseyeds]

I was wondering if using vba, if there is a way to select multiple sheets at once. There is a formula that i want inserted in multiple sheets. I want to be able to create a macro that inserts this formula all at once because there is approx 15 sheets. What i am trying to do is shorthand it to where i dim all the sheets as a variable and then select that variable and run the code. This is obviously not working or i wouldnt be asking for help.

Thanks
KB

 

[Sharkie21]

Not exactly sure what you want to do but I think this is what you're asking for

Public Sub addFormula()
Dim wks As Worksheet
For I = 1 To Application.Worksheets.Count

Set wks = Application.Worksheets(I)
wks.Range("cell you want formula in").Value = "=Formula" // whatever your formula is

Next
End Sub