resize colums / rows in range

[philcud]

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?

[Tom Ogilvy]

Why not just set the zoom back to 90%

ActiveWindow.Zoom = 90

--
Regards,
Tom Ogilvy

"philcud" <philcuddy@gmail.com> wrote in message
news:1122371072.800913.50520@o13g2000cwo.googlegroups.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?
>

[philcud]

the application that opens the spreadsheet 'sees' the spreadsheet at
100% zoom, so unfortunatley need to resize rows and colums..

[Tom Ogilvy]

Although I am not sure what you mean by 'sees',


loop through the columns and reduce the columnwidth by 1/9. loop through
the rows and reduce the rowheight by 1/9.

if that is what you want. (maybe you meant multiply by .9). You might need
to adjust the font size as well.

--
Regards,
Tom Ogilvy


"philcud" <philcuddy@gmail.com> wrote in message
news:1122383009.782111.64220@z14g2000cwz.googlegroups.com...
> the application that opens the spreadsheet 'sees' the spreadsheet at
> 100% zoom, so unfortunatley need to resize rows and colums..
>

[philcud]

yep, exactly, loop through rows and colums in selection and reduce
height / width by 1/9th.

many thanks.

[philcud]

perhaps you thought i was ok with the logic, but unfortunately i cannot
write the code!!
if someone could post the necessary code please!