PDA

View Full Version : Solved: Value of column from selected row



chinkha
10-01-2010, 12:05 AM
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
10-01-2010, 12:32 AM
Range("A" & Activecell.row).Value

chinkha
10-01-2010, 12:36 AM
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.