Hiding Rows
 

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 cel

--
Brian Matlac
-----------------------------------------------------------------------
Brian Matlack's Profile: http://www.excelforum.com/member.php...nfo&userid=350
View this thread: http://www.excelforum.com/showthread.php?threadid=47629

Hiding Rows
 

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

Hiding Rows
 

Works Great Tom Thanks Alot!!


--
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