difference in between activecell.activate and activecell.select

hi,
i want to get back to my cell where i was after tick a checkbox

so which method is fast for processing this code

should i use activecell.activate or activecell.select

hope some one will help

To be honest, you should avoid selecting (or activating) anything, including cells.

Selecting, or activating, a cell causes interaction between VBA and the worksheet which is slow and inefficient.

For what it's worth, for what you say you are trying to do, as a one off, it probably doesn't make a lot of difference. Again, for what it's worth, I’ve never used .Activate.

Originally Posted by TMS

To be honest, you should avoid selecting (or activating) anything, including cells.

Selecting, or activating, a cell causes interaction between VBA and the worksheet which is slow and inefficient.

For what it's worth, for what you say you are trying to do, as a one off, it probably doesn't make a lot of difference. Again, for what it's worth, I’ve never used .Activate.

Thanks for the yours valuable information