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!
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to write a macro to hide an entire row 9
Hiding Columns produces error <----HELP PLEASE 2
hiding blank rows 3
Hide Rows if all values are zero 5
hide colum based on cell value on each worksheets 2
Hide rows using VBA 2
Excel EXCEL - using a date dependant formula to hide rows 3
How to Disable/Enable hide entire row ability 17

Back
Top