Row Select
You may be looking for:
Range("A2") = ActiveCell
--
Vasant
"Syr Doug" wrote in message
...
Hello,
I have a spreadsheet where the first 15 rows are blank and then my data
starts. I have freeze panes on.
I want to display information from the current row that has the cursor.
For example: My cursor is on row 21, I want to display the data from that
row, say cell AD21 in cell A2.
I think I just need the syntax to display the current row
range("A2").value = ???? current row
Thanks
D
|