make camera object refer to dynamic range
 

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