Value of column from selected row

[chinkha]

Hi all,

would like to know the vba command if i need to find out the value of the first column if i select a row. (eg row 45 selected, like to know the value of A45)

thank you in advance.

[Simon Lloyd]

 
Range("A" & Activecell.row).Value

[chinkha]

 
Range("A" & Activecell.row).Value

Thank you so much for the prompt reply.
will test it immediate.
finally can start to work on my model again.