J
Jack
Is that possible?
D
Don Guillett
the active cell IS the activecell
x=activecell.row
y=activecell.column
z=activecell.address
activecell.offset(1,6)
etc, etc.
x=activecell.row
y=activecell.column
z=activecell.address
activecell.offset(1,6)
etc, etc.
J
Jack
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?
I need to make another cell to become ActiveCell without clicking on it but
to be done programmatically.
How to do that?
J
Juan Pablo González
Use the .Activate method:
Range("A1").Activate
altough, in 99% of the cases, it's not necessary to Select/Activate the
objects to work with them.
Range("A1").Activate
altough, in 99% of the cases, it's not necessary to Select/Activate the
objects to work with them.
J
Jack
Thank you. That is what I need. 