View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Decreenisi Decreenisi is offline
external usenet poster
 
Posts: 10
Default find next line for data entry

I have an excel spreadsheet, with over 3000 rows. I have to review and
sort daily, then go back to the next blank row and start entering
data. I am looking for a quick macro I can asign to a button that will
take me to the next free row A?.

Tried this ham fisted code, but not working

'find next line for data entry
Dim CurrentRow As Integer 'this variable will be changed
according to the row being searched
CurrentRow = 13

Do
CurrentRow = CurrentRow + 1
Loop While Worksheets("Concern Log").Range("B" & CurrentRow) < ""