Hi guys
I've got a formula I need to run using a macro, and need it to run from Row 3 of the worksheet to the last used row.
The formula is =vlookup, J3, $BI:$BJ, 2, FALSE) - with the J3 reference incrementing (i.e. J4, J5 etc).
Any ideas on how best to run this using VBA? Any help greatly appreciated.
Regards
Olly
I've got a formula I need to run using a macro, and need it to run from Row 3 of the worksheet to the last used row.
The formula is =vlookup, J3, $BI:$BJ, 2, FALSE) - with the J3 reference incrementing (i.e. J4, J5 etc).
Any ideas on how best to run this using VBA? Any help greatly appreciated.
Regards
Olly