Dear community,
could you please help me with the code I wrote. I would like to hide rows depending which user opens the file:
What I'm doing wrong?Sub Macro1() ' ' Macro1 Macro ' LastRow = 1000 For j = 1 To LastRow If (Range("A" & j) = Environ("Username")) <> True Then Rows("A" & j).EntireRow.Hidden = True Next j End Sub