Tips for optimising page setup .Zoom and .FitTo properties
"Paul Robinson" wrote
This works reasonably well for me. Overdoes things a bit for small
tables. Operates on the UsedRange of the ActiveSheet.
'Simplified version of a function written by Francois Van Wauwe,
Microsoft.Public.Excel.Programming, 25th Sept 1998
This is nice and deterministic. Many thanks!
Frank.
|