Good Afternoon, i'm new in VBA but need to hide some rows based on value in specific cell. i already made this code but if i run the code using alt+f8
Compile Error : Invalid outside procedure is popped. Can u help me ? thanks
Sub Contoh11_1()
If Range("E14").Value = Range("E170") Then
'Menyembunyikan baris
Rows("39:40").Hidden = True
Else
'Menampilkan baris
Rows("39:40").Hidden = False
End If
End Sub
Bookmarks