Use a With...End With construct with fully qualified properties : With « Language Basics « VBA / Excel / Access / Word

1. VBA / Excel / Access / Word
2. Language Basics
3. With

Use a With...End With construct with fully qualified properties

 
Sub sheetDemo()
     With Sheets("Sheet1")
           MsgBox WorksheetFunction.Sum(.Range(.Range("A1"), .Range("A10")))
     End With
End Sub

 

Related examples in the same category