SaxumHS
02-26-2018, 02:48 AM
Hi there,
I want to hide certain rows, depending on a certain cell value of a different worksheet.
The macro works (attachment 1), as long as I target a cell on the same worksheet as the hidden/unhidden rows.
However, when I try to target a cell on a different worksheet ("Projectgegevens"), nothing happens.. (attachment 2)
Below you can see the change between the codes.
Anyone got an idea to get this working?
2169821699
Thanks in advance!
I want to hide certain rows, depending on a certain cell value of a different worksheet.
The macro works (attachment 1), as long as I target a cell on the same worksheet as the hidden/unhidden rows.
However, when I try to target a cell on a different worksheet ("Projectgegevens"), nothing happens.. (attachment 2)
Below you can see the change between the codes.
Anyone got an idea to get this working?
2169821699
Thanks in advance!