Excel macro selecting column

Hello,
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.

Example:
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.

hope someone can help me.

thanks.