software

I have a workbook with several different worksheets in it. I only want to
display a specfic range of cells on a worksheet (i.e. A1-E31). However, it
varies from sheet to sheet. How can I do this?

Select columns F thru IV and hide them.
Select rows 32 thru 65536 and hide them.
--
Gary's Studentquot;Robert Brownquot; wrote:

gt; I have a workbook with several different worksheets in it. I only want to
gt; display a specfic range of cells on a worksheet (i.e. A1-E31). However, it
gt; varies from sheet to sheet. How can I do this?

You can just manually hide the cells on each sheet that you wish not to be
seen. If this is something that has to be done frequently, and with
constantly varying ranges, the you could set up a table of SheetNames and
ranges and a Programmer could prepare code to do the hiding or unhiding
automatically

hth
Vaya con Dios,
Chuck, CABGx3
quot;Gary''s Studentquot; wrote:

gt; Select columns F thru IV and hide them.
gt; Select rows 32 thru 65536 and hide them.
gt; --
gt; Gary's Student
gt;
gt;
gt; quot;Robert Brownquot; wrote:
gt;
gt; gt; I have a workbook with several different worksheets in it. I only want to
gt; gt; display a specfic range of cells on a worksheet (i.e. A1-E31). However, it
gt; gt; varies from sheet to sheet. How can I do this?