Need to recalc on selection and be able to copy and paste

[BillDoor]

Hi I have a workbook with custom functions to measure the total row height and column width of a range. But is doesn't recalculate when you adjust the size automatically, so I added a little code to each sheet to recalculate when any cell is selected
Private sub change(ByVal target as range)
Calculate
End sub

But this stops the user being able to copy and paste in the sheet as it seems to clear the clipboard
Is there any way around this, other than having options to use application.enableevents=false

Thanks

[JYTS]

YES! There is a way round this.

Open up the custom function (a/k/a UDF - user defined function) and add this line

Please Login or Register  to view this content.

Anytime any calculation occurs on the worksheet, the affected UDF will recalculate. Since it is part of a UDF, the undo/redo stack is not cleared.