Hi,

I have a worksheet and in column D i have several amounts, all numbers. I'm using the on double click worksheet event to trigger a macro when one of these cells is the 'Target'. I want the value of that cell to be available as public variable, so I can use it in modules called by the on double click event.

I've tried declaring it as Public in a normal module but I couldn't get it work.

thanks in advance for any help.