Column A of current row - "Home"

A

al

need a code which would take me to Column A of current active cell -
when recording action with shortcut "Home" - i'm not getting the
correct macro.
Pls help - thxs
 
J

Jim Cone

Cells(ActiveCell.Row, 1).Select
--
Jim Cone
Portland, Oregon USA



"al" <[email protected]>
wrote in message
need a code which would take me to Column A of current active cell -
when recording action with shortcut "Home" - i'm not getting the
correct macro.
Pls help - thxs
 
A

al

Cells(ActiveCell.Row, 1).Select
--
Jim Cone
Portland, Oregon USA

"al" <[email protected]>
wrote in message
need a code which would take me to Column A of current active cell -
when recording action with shortcut "Home" - i'm not getting the
correct macro.
Pls help - thxs
Click to expand...

thxs
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Autofilter - Contains 3
Loop to determine number of rows range 1
Import multiple workbooks to current workbook in specified row number 0
Rename active sheet with current file name 5
Control-Home key behaviour 1
Count every group of numbers whose sum is zero & put number next toeach number 6
Copy row on criteria 4
selection of cell at the intersection of column B and the row ofwhatever cell is active 8

Top