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

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