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" <Brian.Matlack.1wwj6d_1129309525.4873@excelforum-nospam.com>
wrote in message
news:Brian.Matlack.1wwj6d_1129309525.4873@excelforum-nospam.com...
>
> 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!!