UDF Not Recalculating

tanha

Registered User.
Local time
Today, 19:22
Joined
Apr 9, 2007
Messages
80
Hi.
Suppose I have the following UDF, which returns the width of the column, but when the column width change (increase or decrease), the UDF is not able to recalculate the column width...what should I do?

Code:
'**************** Returns the column width of the active cell.
Public Function COLUMNWIDTH() 
Call Application.Volatile(True)
      COLUMNWIDTH = ActiveCell.COLUMNWIDTH
End Function
'**************** Returns the column width of the active cell.
 

Users who are viewing this thread

Back
Top Bottom