Well, it's one of those days,

There I was happily programming away in VB and someone comes along with an urgent Excel problem.

Without going into the detail of the whole requirement, what I need to do is if somebody clicks on a particular cell, I need to send the selected cell region elsewhere.

I have managed to select a different cell OK by using

Sheet1.Range("nm").Activate

So, for example, if the user clicks on A1 and that is one of the special cells, I pop up a message and select B1 instead.

What I would like to do is to have no cell selected if the user clicks on A1.

Is this possible?

Any help would be appreciated.