PDA

View Full Version : Hide current Roll based on Cell value



xaxaredbul
01-30-2019, 12:36 AM
Hello ,

i need help to make macro that is hiding each current roll based on cell value in column A.

Thank you!

大灰狼1976
01-30-2019, 06:49 PM
Hi xaxaredbul!
For a simple example as below:

Sub aaa()
Dim i&
For i = 1 To 100
If Cells(i, 1) = "abc" Then Rows(i).Hidden = True
Next i
End Sub