Excel - Deselect all

For some reason I cannot find what I would think would be a common request. I would like to deselect anything that may be selected on an Excel document before my script begins to execute other tasks. Reason being, an operator may have clicked in a cell or highlighted a row (by mistake) and this in turn would cause my larger script to fail.

Any help would be greatly appreciated.


I don’t think that there is a deselect option. There is always an active cell — even when you create a new workbook.

Consider activating a particular cell that would not be troublesome to your script.

activate object range "A1" of worksheet 1

Thank you Mockman, I will go with that approach. I very much appreciate your quick response.


1 Like