Autofit column after formula recalc

[rdw72777]

I've seen numerous macros that allow the user to resize a range of columns using autofit. Is there a way that, without using code, that a column can be forced to resize when the resulting formula in a cell in that column returns results of varying widths?

 

[Fazza]

Double click on the header or via the menu, ALT-O-C-A. HTH

 

[rdw72777]

Is there a way to have this happen automatically?

I'm building a series of 50 columns and 1000 rows, and every time a a different selection is picked from a drop down (data validation - list), all of these formulas will recalculate. When this happens, I'd like the columns to resize automatically. And trying to avoid VBA.

 

[Fazza]

AFAIK, you'll need VBA.

What about cheating a little - using a smaller font?

 

[rdw72777]

Well it could be anywhere from 20 characters long to 60+ characters long, so cheating will just make things look awkward.

 

[Fazza]

just in case it helps. with a query table or pivot table column widths can automatically vary without VBA