Hiding Rows in a VBA macro

Giganews Newsgroups
Subject: Hiding Rows in a VBA macro
Posted by:  sarcher (sarcher.27urrn_1147703101.7543@excelforum-nospam.com)
Date: Mon, 15 May 2006

Hi,

I want to set up a looping macro in VBA so that it looks at the first
column of the work book and if this is empty, the entire row is
hidden.

I have got the code below - the lopping works just cant get the correct
code for hidding the row.

SUB PRINTPAGE()

DIM MAIN AS WORKSHEET
DIM MROW AS LONG
SET MAIN = THISWORKBOOK.WORKSHEETS(\"WORKPLANNER\")
MROW = 8

DO UNTIL MROW = 352

IF MAIN.CELLS(MROW, 1) = \"\" THEN
-MAIN.CELLS(MROW, \"\") = \"TEST\"-ELSE
END IF
MROW = MROW + 1
LOOP
END SUB

also when i print a worksheet with a number of hidden rows is there a
way for Excel to ignore these completely.

Thanks

Steven

--
sarcher
------------------------------------------------------------------------
sarcher's Profile:http://www.excelforum.com/member.php?action=getinfo&userid=34457
View this thread:http://www.excelforum.com/showthread.php?threadid=542123

Replies