Jan Karel,

That is not right. Just change

clearAround (target)

to

clearAround target

and it works.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Jan Karel Pieterse" wrote in message
...
Hi Ph8,

For some reason I am getting an error when attempting to do this.
Could anyone explain why?

You cannot declare a function argument which is an object using byval,
it must be passed byref.

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com