Hi,
I am trying to set a formula by looping through cells but am a bit stuck. I am using the following;
For i = 5 To 10
For j = "B" To "Z"
Sheets("Infections").Range(j & i).Formula = "my formula"
Next j
Next i
I get a type mismatch error on 'j'. Can someone point me in the right direction of how to solve this?
Thanks in advance
Jonathan
Bookmarks