Id rather use:

Range("myname").rows("7:10").entirerow.hidden = True/False

--
AP

"Ctech" a écrit dans le
message de ...

Hi have a named range with 10 rows...

I want to mark/hide the last 3 rows of this range depending on a cell
value...


anyone know how to do this?


--
Ctech


------------------------------------------------------------------------
Ctech's Profile:
http://www.excelforum.com/member.php...o&userid=27745
View this thread: http://www.excelforum.com/showthread...hreadid=524754