when you want to retain the activecell
and its not on the same row, you need a multiarea select
like:

Union(ActiveCell, Rows(13)).Select

dont use rows(currentrow

use Cells(currentRow,desiredCol).Select
or
activecell.entirerow.cells(desiredCol).select
or
activecell.entirerow.columns(desiredCol).select
or again to retain the activecell

union(activecell,cells(activecell.row,desiredCol)) .select

many roads to Rome :)


--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


Jack wrote :

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