Hi ExcelMonkey,

I am wrapping a function around a public variable called Cell. When I run
the macro, the code breaks with a Run Time Error 13. However when I hit F8
it allows me to step through it. I can't figure out why its breaking in the
first place. Do I have to further dimenion it within the function?

1. Don't use Cell for a variable name, better to use some name that describes
what it stands for: rActiveCell as Range
2. You don't assign Cell to any object in your code, e.g.
Set rActiveCell=ActiveCell

Regards,

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