Thread: Row Select
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Syr Doug Syr Doug is offline
external usenet poster
 
Posts: 3
Default Row Select

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 ro
range("A2").value = ???? current row

Thank