Hi Bob,

Thanks for the reply. I am guessing this is a macro code that I need to
put in somewhere? I am still pretty much a beginner with these (pretty
much at the stage where I can record them and have a look at them that
way) so if you could tell me how to put it into my workbook that would
be great.

Bob Phillips Wrote:
Rows(10).Hidden = Cells(10,"B").Value ="" AND Cells(10,"C").Value = ""



Is the 10 in this referring to a number of rows?

Being more specific, I am looking to apply this rule to rows 7 to 42,
and then rows 166 to 196
Thanks a lot for your help

Carl


--
mr_teacher
------------------------------------------------------------------------
mr_teacher's Profile: http://www.excelforum.com/member.php...o&userid=34352
View this thread: http://www.excelforum.com/showthread...hreadid=567408