Selecting only active range

[oz_saar]

hi all
can some one please help with a function to select only active range ?

thanks
oz.

[Norman Jones]

Hi Oz,

Your request is not clear.

How does the active range differ from the current selection?

---
Regards,
Norman



"oz_saar" <[email protected]> wrote in
message news:[email protected]...
>
> hi all
> can some one please help with a function to select only active range ?
>
> thanks
> oz.
>
>
> --
> oz_saar
> ------------------------------------------------------------------------
> oz_saar's Profile:
> http://www.excelforum.com/member.php...o&userid=23131
> View this thread: http://www.excelforum.com/showthread...hreadid=394564
>

[oz_saar]

hi again,
what i mean is that i have a table with some data.
the table size is changing (the data is coming from ODBC).
in adition i have cells with formulas near the table, some of the formula have a resault and some dont .
i want to select automaticly only the range containing data, and not all cells with formula.
if the formula resault = nothing then the cell should be out of the sected range.
all of this in order to print only the range that is relevant and not getting empty papers out of the printer.

thanks
oz.