Rows(10).Hidden = Cells(10,"B").Value ="" AND Cells(10,"C").Value = ""
--
HTH
Bob Phillips
(replace somewhere in email address with gmail if mailing direct)
"mr_teacher" wrote
in message ...
Is it possible to hide all of a row based on a condition if there is no
data in column b and c for that row it should be hidden, or if there is
data in either of these columns then that row should be unhidden?
This would need to be applied to certain sections only of the worksheet
not the whole sheet.
Any ideas on how to do this or if it can be done?
Thanks 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