Is there a way to simulate a 'Hide Column' Event?
 

Hi All,

I have a worksheet which includes a cell that returns the number of
visible columns in a range.

This formula updates whenever the worksheet re-calculates.

I have tried making the formula 'volatile' by multiplying the result
by (Now()/Now()) but when a user hides a column, neither the
worksheet_calculation event nor the worksheet_change event is
triggered, and hence my formula does not update until / unless
something else happens.

Is there any way to simulate a 'column_hide' event that I can use to
force a re-calculation?

Thanks,

Alan.