I need to select a specific column relative to the active cell in a macro. Specifically, regardless of the Active cell on a given row, I want to select the F column for the row the activecell is on.
When my macro is executed the active cell is N3. I want the macro to select F3 for me or
if my active cell is R8, I want the macro to select F8 for me.
The goal is to position the activecell to a specific cell before the rest of the macro is executed, however that specific cell is dependent on the last row where data has been entered.