Dear Harald

Thanks so much for the reply and the neat code that does exactly what I
asked.

UNFORTUNATELY I did not word my request well.

I have a very large spreadsheet that uses code to navigate to any one of
about 200 CUSTOM VIEWS.

Each custom view is the same size as any other but each contains
different data for different people.

Everything worked fine until I loaded a demo onto my boss's computer.

He has a much higher res screen so my precisely defined block of data
ends up as a tiny square on his screen.

I need code that will make a block of cells defined by the "View",
"Custom View", menu command as say "Employee_47_Month_November"
reasonably fill any screen whether 640x480 or 1600x1280. Doesn't have to
fill exactly, as long as all cells in the custom view are visible.

I am begining to wonder if it is possible.?????

Thanks again Harald

Darryl




*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!