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