AHHHHHH! Excel VBA Help!

G

Guest

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
 
F

Frank Kabel

Hi
activecell.offset(1,0).select

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy down (propagate) function/forumula needed 4
Need macro for copying random lines of data 3
Adjust tab key function and enter key function in Excel 2
Copy/Paste 2
Excel Trying to code an Array Function in VBA Excel to works as a MaxIF 3
copy/paste won't refer to the appropriate range of cells 1
Double Clicking 2
Displaying zeros in cells 2

Top