Quote Originally Posted by mdmackillop
Check that is is a valid range before passing it to the sub routine. Consider
[vba]
MsgBox TypeName(Selection)
[/vba] You can use this result to determine how the code proceeds.
Md, that is actually what i did to solve the problem, except i did it in the immediate window.

I just wanted to get your opinion on whether I was doing my testing correctly !