How this statement will work

[bhandari]

WorksheetFunction.Sum(Worksheets("Sheet2").Range(Range("A1"), Range("A7")))

 

[wideboydixon]

If Sheet2 is the currently active sheet, it will return the sum of cells A1:A7. If Sheet2 is not the currently active sheet, it will return an error. The more complete statement that won't give an error when Sheet2 isn't active is:

WorksheetFunction.Sum(Worksheets("Sheet2").Range(Worksheets("Sheet2").Range("A1"), Worksheets("Sheet2").Range("A7")))

WBD