selecting first available blank row in column
Posted by richey on February 08, 2002 9:51 AM
I've got this code running, which although works takes time. I need to know how I can say
and then find the first empty row and put the cursor in the cell within column a
at the moment I've got the following which works but loops through and takes time. if the first empty row is say row 400 it takes time.
any help much appreciated
Worksheets("User Survey_new").Cells(1, 1).Select
Do While Not IsEmpty(ActiveCell)