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

--
Regards,
Tom Ogilvy


"Brian Matlack"
wrote in message
news:Brian.Matlack.1wwj6d_1129309525.4873@excelfor um-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