Hi Guys - some help please.
I am trying to hide rows in another worksheet without selecting it. My current code is as follows:
---------------------------------------------------------------------
Sub modRowHide(SheetName As String, RowName As String, QtyCell As String)
Sheets(SheetName).Select
Range(RowName).Select
Selection.EntireRow.Hidden = True
Sheets("Menu").Select
Range(QtyCell).Select
Selection.Font.ColorIndex = 2
ActiveCell.FormulaR1C1 = "0"
End Sub
----------------------------------------------------------------------
Problem is that the constant jumping between sheets every time it makes it an active sheet is irretating to the eye as the module is run several times in repeat.
Any suggestions?