Function Sum_Visible_Cells(ByRef Cells_To_Sum As String)
Application.Volatile
Range(Cells_To_Sum).SpecialCells(xlCellTypeVisible).Select
Sum_Visible_Cells = WorksheetFunction.Sum(Selection)
End Function
Subscribe to:
Post Comments (Atom)
Welcome to this blog... here you get some excellent short cuts for some difficult excel VBA programming logic.
No comments:
Post a Comment