Excel macro selecting column

[Closed]
Report
-
 Carla -
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.

2 replies

Posts
11
Registration date
Thursday October 16, 2008
Status
Member
Last seen
May 12, 2009
1
hi,
try this link to get help about creating excel macros:
http://www.excel-vba.com/excel-vba-contents.htm
1
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2942 users have said thank you to us this month

Hello,

This code line should work:

Cells(ActiveCell.Row, 6).Select

http://www.excel-vba-easy.com/vba-programming-range-excel-vba.html
1
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2942 users have said thank you to us this month