I need certain rows in a worksheet "Printsheet" to either be hidden or shown based on the contents of specific cells in another worksheet "Input".
I was thinking something like this but I am not having much success.
If Printsheet.Cells.Range(5, 5) = "A" Then
Printsheet.Rows("39:52").Hidden = True
I am pretty new to this so please don't hesitate to "dumb" down any suggestions you may have.
Thanks in advance for any help anyone can offer.
Tyler
I was thinking something like this but I am not having much success.
If Printsheet.Cells.Range(5, 5) = "A" Then
Printsheet.Rows("39:52").Hidden = True
I am pretty new to this so please don't hesitate to "dumb" down any suggestions you may have.
Thanks in advance for any help anyone can offer.
Tyler