View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Frank_Hamersley Frank_Hamersley is offline
external usenet poster
 
Posts: 12
Default 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.