Thread: How to set programmatically focus on specified Excel row?
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming,microsoft.public.vb.general.discussion
Dave Peterson Dave Peterson is offline
external usenet poster
  
Posts: 35,218
Default How to set programmatically focus on specified Excel row?
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
Reply With QuoteReply With Quote