Selecting range of cells whilst 'event selection procedure' runs in the background

Hi.
I'm having some trouble with target cells in event procedure, when i select any range of more than two cells (for cell formatting purposes) the debugger goes on but not sure why?
Here is my code:

Please Login or Register  to view this content.

I added this and it works now

Please Login or Register  to view this content.

Hi,

Your problem was caused by Target.Row and Target.Column and Target.Value being illegal when more than one cell was selected.

If you limit selection to one cell only try the following:

Please Login or Register  to view this content.

Please NOTE: When using Excel 2003 replace CountLarge with Count, because CountLarge is NOT available in Excel 2003.



If selecting more than one cell is allowed try:

Please Login or Register  to view this content.

Lewis

Your solution in post #2 still causes a runtime error for me, when selecting more than one cell.

Dear Lewis,
I actually did want to have the option of selecting more than one cell but i thought that would be impossible so i inserted in my code the exit sub if i selected anything outside the range mentioned in the code. It did not take care of the issue if i selected more than one cell within the range mentioned in the code, but once again, i thought there was no way out.
The second code you posted is originally what i was looking for and it works flawlessly! Thank you.

P.S. sometimes i think it would be impossible to get a solution to certain vba questions i have but then i am proven wrong.
You inspire me

Thank you.