Archive of Mr Excel Message Board


Back to Excel VBA archive index
Back to archive home



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?

Check out our Excel VBA Resources

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

Posted by Daniel P. on January 03, 2001 7:40 AM
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.




This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.