On Thu, 20 May 2004 11:06:05 +0100, "Bob Phillips"
wrote:


Activecell.Offset(1,0).Select

Glorious! My macro works perfectly now!

Thank you!

--

HTH

It sure did!

I know have a spreadsheet that has buttons with macros assigned to
them that are found in the workbook itself, all of which has allowed
me to put some great db-like functionality into a spreadsheet! I just
earned my pay! I found out this weekend about how to do all of this.
For years I've been assigning macros to the toolbar but not making
standalone files in this way. Excel is one of the few programs, like
WordPerfect, that has never let me down all these years. No matter
what I've needed, it's come through! Awesome!

:oD

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"StargateFan" wrote in message
.. .
I have a macro in an Excel worksheet that just needs one step added,
to move the cursor one cell down from its current position. Can
someone tell me what the code for that would be?

When I add record the keystroke via moving the down arrow one cell
down, it actually adds the cell reference, which is no good.

Thanks!