Volatile UDF v ws_change conflict

Giganews Newsgroups
Subject: Volatile UDF v ws_change conflict
Posted by:  The Cube (mind-the-g…@DEEPblueyonder.co.uk)
Date: Sat, 4 Oct 2003

Hi all

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
it.
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
planned.
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
overcoming this?

Thanks

-Cube

Replies