offset to reach extreme left cell in column A

[Mr.Karr]

Hello

Can anyone please provide a code snippet so to move the cursor or select the extreme cell in left side of column A.

In detail: Say.. I need to paste certain free text parallel to the cell user selects, I have data from column A to AZ. I tried using offset function but it's not giving accurate results or probably I'm trying it better.

Can anyone help to get this done?

Thanks in advance

 

[Graeme]

Assuming you want the cell in column A that is on the same row as the activecell, this should work:

Cells(ActiveCell.Row, 1).Select

 

[Mr.Karr]

thanks @Graeme. I will give it a try

 

[Graeme]

You're welcome.