LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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) < ""
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
where can i find grid data entry in excel? JMH New Users to Excel 3 April 22nd 07 10:56 AM
Cell Entry That Locks Selected Cells From Any Data Entry. ron Excel Worksheet Functions 5 February 16th 07 09:52 PM
where on earth can I find data entry forms in Excel 2007 retep Excel Discussion (Misc queries) 4 February 10th 07 02:14 PM
Can't seem to find way to have easy data entry AND analysis - idea Heidi Excel Discussion (Misc queries) 2 January 2nd 07 11:24 PM
How do I find an unknown value on a line made from known data? brendas182 Excel Discussion (Misc queries) 2 June 30th 05 03:33 AM


All times are GMT +1. The time now is 11:43 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"