AHHHHHH! Excel VBA Help!

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Chris - 21 Jul 2004 22:25 GMT

Ok, going nuts. How do you say "go to the next cell down" in VBA? ex:
I'm pasting something into cell A23 and would normally hit enter to go to
cell A24. TIA

-Chris

Reply to this Message

Frank Kabel - 21 Jul 2004 22:30 GMT

Hi
activecell.offset(1,0).select

Note: In most cases no need for select / activate. Simply use
Activecell.offset(1,0).value="some value"

Signature

--
Regards
Frank Kabel
Frankfurt, Germany

> Ok, going nuts. How do you say "go to the next cell down" in VBA? ex:
> I'm pasting something into cell A23 and would normally hit enter to go to
> cell A24. TIA
>
> -Chris

Reply to this Message

Chris - 21 Jul 2004 22:39 GMT

THANKS! Worked Great!

> Ok, going nuts. How do you say "go to the next cell down" in VBA? ex:
> I'm pasting something into cell A23 and would normally hit enter to go to
> cell A24. TIA
>
> -Chris

Reply to this Message