VBA help, select the next cell down
Posted by Edgar on January 03, 2001 6:36 AM
Here is my objective and my dilemma. I have 140 records
which I need to fill out a form for, but I want to automate
this with a macro. I almost have it complete but I'm missing
one element. Selecting the next cell down without specifying
the actual cell range. I hope this makes sense.
I created a macro that takes the value from one table, cells
(A23 to A162) then, by pasting that value into a cell in the form,
using vlookup to fill in the blanks on the form, then copying the
sheet, selecting all cells, copying and pasting values only (thus
removing all formulas, I have the macro then go back
to the info sheet and end up back to the cell where I started.
What I want to do is to select the next cell down, then
I want it to stop if the cell below that is empty. Basically, I need
to fill out one form for each record. Can anyone help, please?