VBA Help - Hiding Rows

  • Thread starter Thread starter cmoreno
  • Start date Start date
C

cmoreno

Hi there,

I really need some help. I'm trying to write some pretty basic VB
code, but I'm having trouble getting it to work. Here's the setup:

I have a column that spits out the word "HIDE" in a cell if I want the
entire row to be hidden. Now I'm trying to write a macro which
automates the hiding process. Any help you can give will be much
appreciated.

Thanks!
 
Hi

Build some loop that will cycle through the cells in the column (for, while - depends on how you want to determine the range of cells to check). The following will hide the row.
If ActiveCell = "HIDE" Then Rows(ActiveCell.Row).EntireRow.Hidden = True

Tony

----- cmoreno > wrote: -----

Hi there,

I really need some help. I'm trying to write some pretty basic VB
code, but I'm having trouble getting it to work. Here's the setup:

I have a column that spits out the word "HIDE" in a cell if I want the
entire row to be hidden. Now I'm trying to write a macro which
automates the hiding process. Any help you can give will be much
appreciated.

Thanks!
 
Back
Top