Hello All,
I have report contains more than 150 sheets, so based on the “H” column It will visible also every sheet “F1” cell needs to update the “True” if the sheets were visible then. So here the problem is it will take too much time to visible the sheets and update the “F1” cell value.
Can you suggest me how to speedy the below said macro?.
Sub Ran_Select()
LRow = ThisWorkbook.Sheets("Summary").Range("H10").End(xlDown).Row
For i = 10 To LRow
ws = Worksheets("Summary").Range("E" & i).Value
If Worksheets("Summary").Range("H" & i).Value = "YES" Then
Worksheets(ws).Visible = True
Worksheets(ws).Range("F1").Value = True
Else
Worksheets(ws).Visible = False
Worksheets(ws).Range("F1").Value = False
End If
Next i
MsgBox ("It's done")
Sheets(“Summary”).select
End Sub
Thanks/Raju
Bookmarks