Excel within vb6

I am working on a program that opens up excel in vb6 and moves the capures the contents of a specific cell, what I would like to do ie automatically select the next cell in the sequence(ie from d4 to e4) without selecting the next cell as e4.
some thing like first cell +1 ? is this possible?
Also I would like to select the last cell say in the "e" col, without
knowing it's cell address?
I would really appreciate any advice.

Msgbox Worksheets("Sheet1").Range((Worksheets("Sheet1").Col +1) & "4")

Try that "untested"