Jack,
You said you wanted "to programmatically make cell an ActiveCell".
So the previous ActiveCell will no longer be active.

It is normally not necessary to .Select object in VBA to use them. Do you
really need to move the ActiveCell/selection ?

NickHK

"Jack" <replyTo@newsgroup wrote in message
...
Thank you.
Using .Select works.
However I am "loosing" the ActiveCell, when using Rows().Select
Before selecting the row I had specified ActiveCell.
When Rows().select is done the first cell in that row becomes active. I do
not want that.
Jack
"Dave Peterson" wrote in message
...
oExcel.cells(CurrentRow, CurrentCol).Activate

????

Jack wrote:

I forgot to add.
When I try:
oExcel.Rows(CurrentRow, CurrentCol).Activate
I do have an error.

"Jack" <replyTo@newsgroup wrote in message
...
Hello,
1.
How to programmatically move focus from one Excel row into next one?
2.
How to programmatically make cell an ActiveCell?

Your thoughts appreciated,
Jack



--

Dave Peterson