G
Guest
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
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