[RESOLVED] move down one cell

[LITTLE AT A TIME]

[Highlight=VB]

Application.Goto Reference:="_3100010"
selection.End(xlDown).Select...............

ok ....i went to reference _3100010

A) now i want to goto the last input item in that colume and move down one cell
for input in that colume in the next blank cell

who?????

B) also if i want it to always goto a new reference spot and i need to input the new reference every time how do i accomplish that?????

C) any tricks to learning this stuff?

[RobDog888]

Tricks: Record a macro of you performing your desired task and then check out the generated macro code - http://vbforums.com/showthread.php?t=402032

Check out the .Offset and .SpecialCells methods.