IF THEN-HIDDEN ROWS
 

I have a macro on a sheet that when a cell says "no" some rows (i.e. 1-10) on
sheet2 will hide. When I go to sheet2 to type some rows appear (i.e. 2-10).
I have a macro on sheet2 that also will hide some rows when cell in row 1=NO
then rows 2-10 will hide.

I find that all the rows that were once hidden from sheet1 are now appearing
that have the same row numbers in my code as sheet2.

Can I create an IF THEN statement to state that if the code from sheet1
hides a row then the row cannot appear unless the cell in sheet1 says yes?

Thank you,

daniel Young

IF THEN-HIDDEN ROWS
 

Hi Daniel,

It would be helpful to see the code you are using to hide the rows.

Regards,
James

"Daniel R. Young" wrote:

I have a macro on a sheet that when a cell says "no" some rows (i.e. 1-10) on
sheet2 will hide. When I go to sheet2 to type some rows appear (i.e. 2-10).
I have a macro on sheet2 that also will hide some rows when cell in row 1=NO
then rows 2-10 will hide.

I find that all the rows that were once hidden from sheet1 are now appearing
that have the same row numbers in my code as sheet2.

Can I create an IF THEN statement to state that if the code from sheet1
hides a row then the row cannot appear unless the cell in sheet1 says yes?

Thank you,

daniel Young