Goto column A of the ActiveCell
 

If someone had cell D6, I want the macro to goto to cell A6

If someone had cell T56, I want the macro to goto to cell A56

-ADK

Goto column A of the ActiveCell
 

The following will do that for you:

Sub GoToA()

Dim lngRow As Long

lngRow = ActiveCell.Row
Range("A" & lngRow).Select

End Sub

--
Kevin Backmann


"ADK" wrote:

If someone had cell D6, I want the macro to goto to cell A6

If someone had cell T56, I want the macro to goto to cell A56

-ADK

Goto column A of the ActiveCell
 

Not sure what test you want to carry out with your if statement but

Range("A" & Activecell.Row).select

will take you to column A on the same row as the selected cell.


ADK wrote:
If someone had cell D6, I want the macro to goto to cell A6

If someone had cell T56, I want the macro to goto to cell A56

-ADK

Goto column A of the ActiveCell
 

thanks, this will work

"Alan" wrote in message
ups.com...
Not sure what test you want to carry out with your if statement but

Range("A" & Activecell.Row).select

will take you to column A on the same row as the selected cell.


ADK wrote:
If someone had cell D6, I want the macro to goto to cell A6

If someone had cell T56, I want the macro to goto to cell A56

-ADK