ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   How to programmatically make a cell the Active Cell? (https://www.excelbanter.com/excel-programming/298188-how-programmatically-make-cell-active-cell.html)

jack

How to programmatically make a cell the Active Cell?
 
Is that possible?



Don Guillett[_4_]

How to programmatically make a cell the Active Cell?
 
the active cell IS the activecell

x=activecell.row
y=activecell.column
z=activecell.address
activecell.offset(1,6)
etc, etc.
--
Don Guillett
SalesAid Software

"Jack" <replyto@newsgroup wrote in message
...
Is that possible?





jack

How to programmatically make a cell the Active Cell?
 
Maybe it was not clearly said.
I need to make another cell to become ActiveCell without clicking on it but
to be done programmatically.
How to do that?

"Don Guillett" wrote in message
...
the active cell IS the activecell

x=activecell.row
y=activecell.column
z=activecell.address
activecell.offset(1,6)
etc, etc.
--
Don Guillett
SalesAid Software

"Jack" <replyto@newsgroup wrote in message
...
Is that possible?







jack

How to programmatically make a cell the Active Cell?
 
Thank you. That is what I need. :)

"Jack" <replyto@newsgroup wrote in message
...
Is that possible?






All times are GMT +1. The time now is 01:12 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com