Thread: Formula for selecting the second row down (Not necessarily row "2"
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Rick Rothstein \(MVP - VB\) Rick Rothstein \(MVP - VB\) is offline
external usenet poster
  
Posts: 2,202
Default Formula for selecting the second row down (Not necessarily row "2"
The second row down from what?

Rick


"Megadrone" wrote in message
...
I have the following command:

lastrow=Cells(Rows.count, "A").End(xlup).Row

I need the formula to select the second row down

Reply With QuoteReply With Quote