Why not just set the zoom back to 90%

ActiveWindow.Zoom = 90

--
Regards,
Tom Ogilvy

"philcud" wrote in message
ups.com...
i have a spreadsheet that is zoomed to 90%. this is then accessed
through a vb app which opens it at 100%, and so is to big.

how can i reduce the width / height by a proportion of 1/9th for all
rows / colums in a selected range?