Hiding Rows

[Brian Matlack]

Hi!
I am working in Excel 2003.
How can I hide a variable number of rows useing a cell reference.
I currently use a series of "If" "Then"s and refer to a count cell

[Tom Ogilvy]

numrows = Range("B9").Value
activecell.Resize(numrows,1).EntireRow.Hidden = True

--
Regards,
Tom Ogilvy


"Brian Matlack" <[email protected]>
wrote in message
news:[email protected]...
>
> Hi!
> I am working in Excel 2003.
> How can I hide a variable number of rows useing a cell reference.
> I currently use a series of "If" "Then"s and refer to a count cell
>
>
> --
> Brian Matlack
> ------------------------------------------------------------------------
> Brian Matlack's Profile:
http://www.excelforum.com/member.php...fo&userid=3508
> View this thread: http://www.excelforum.com/showthread...hreadid=476295
>

[Brian Matlack]

Works Great Tom Thanks Alot!!