Hide rows using macros

B

Benoit

Hello,

Simple question (I think) for any advance VBA folks out there...

In a worksheet, I need to have a macro that will check rows 12 to 212. If
cell "A" is empty, then I need the row to be hidden.

Thanks in advance for your help!!!
 
D

db

maybe you can use
condition formatting.

if the cell is blank,
then the data in the
rows are colored "white"

white to blend data
into the white
background

--

db·´¯`·...¸><)))º>
DatabaseBen, Retired Professional
- Systems Analyst
- Database Developer
- Accountancy
- Veteran of the Armed Forces
- Microsoft Partner
- @hotmail.com
~~~~~~~~~~"share the nirvana" - dbZen
 
Top