Set Window Size based on Cell Reference

Basically the code works something like this:

- Click on cell H1
- open a new window
- resize the active window to the named range ("labor")
- center active window to center of the screen

The area I'm having problems with is resizing the active window to the range selected. While it is possible to manually adjust the width and height until it works, I'd like to be able to base this off cell references. It's easy enough to get the max column (c) and row (r) from the named range, but is it possible to set the window limits to not exceed c (width) and not exceed r (height) ?

Please Login or Register  to view this content.

These are not exact calculations, but closer to your needs.

Please Login or Register  to view this content.

Artik

Thanks Artik! Works as expected. I modified it a little to better demonstrate the general concept of what I was after in the attached file for anyone interested.