MrExcel Consulting
Your One Stop for Excel Tips & Solutions

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?

Posted by Daniel P. on January 03, 2001 7:40 AM

Re: VBA help, sel.. (ActiveCell.offset...)

I think you are looking for something like this...

ActiveCell.Offset(1, 0).Range("A1").Select

To avoid recording cell references, click the "Relative Reference" button on the macro bar right before you arrow down.

I hope this is what you are looking for.
Daniel P.