make camera object refer to dynamic range

M

Mica

I have a camera object that refers to a range on another spreadsheet. When
the user makes a selection the range filters to show only matching records.
Unfortunately, the camera object does not resize to show only rows with data.
Is there a way to make the camera object dynamic so that it will expand and
contract based on the size of the currently filtered range?

Thanks,

- Mica
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top