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.