In VBA you need to double click the worksheet containing the cell.

This should cause a new code window to pop up.

Type it in there.

Nick Shinkins

"Darin Kramer" wrote:



Thanks it sounds like the right thing... I have tried to just insert it
as a new module within VBA, but it doesnt seem to work...? whre do I
need to insert it?

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!