I am looking for a way to loop through letters 'C' to 'BX' to populate cells in an excel spreadsheet with a formula.
This is my code:
ActiveCell.Formula = "=VLOOKUP(C4, Data!G3:EA87, 34, FALSE)"
I want to create a loop that will increment C4 to D4, E4, F4.....all the way up to BX.
I'm sure there must be a simple way to do this?
Right now I'm manually changing the letter and executing the code over and over, which is very tedious!