How to programmatically make a cell the Active Cell?

  • Thread starter Thread starter Jack
  • Start date Start date
the active cell IS the activecell

x=activecell.row
y=activecell.column
z=activecell.address
activecell.offset(1,6)
etc, etc.
 
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?
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

I want to make One Cell mandatory if another cell has a specific value , can anyone help me? 0
HELP!!! I can't set formula to cell 1
Selecting data programmatically 6
VBA set thick borders around non empty cells in range 0
Programmatically setting Conditional Formatting to a range of cells 7
Determing range name that is tied to the active cell 6
Find a merged cell 3
Excel Highlight active cell with font color? 3

Back
Top