View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Geo Siggy Geo Siggy is offline
external usenet poster
 
Posts: 1
Default Excel VBA - Automatic adjusting of 2 windows

My Excel application is splitted into two horizontal windows (not
panes), the one above is a diagram with fixed size in height. The one
below is a normal calculation sheet. The problem is how to program in
VBA, that the window below always will fill the remaining space of the
Excel spreadsheet (the remaining space is depending of the monitor,
resolution, the chosen toolbars etc).

Thanx Siggy


---
Message posted from http://www.ExcelForum.com/