|Subject:||Volatile UDF v ws_change conflict|
|Posted by:||The Cube (mind-the-g…@DEEPblueyonder.co.uk)|
|Date:||Sat, 4 Oct 2003|
In a worksheet there are cells that call an Application.Volatile UDF.
The UDF does nothing other than return the rowheight of the cell that calls
That worksheet also has a Worksheet_Change() event handler.
If I delete the cells that call the UDF then the Worksheet_Change() routine
works as planned.
If I un-volatile the UDF then the Worksheet_Change() routine works as
But if I leave the UDF in the worksheet and leave it volatile (required)
then the Worksheet_Change() event misbehaves.
I shall post the full code of the UDF and the Worksheet_Change() if it would
help, but I was thinking that perhaps there is a standard procedure for