Sum cell range on specified worksheet

[sricketts]

I have the following line of VBA code that sums a range of cells on the active worksheet. I need to change that to sum on a specified worksheet. Is there a way to do that? I thought it would be simple, but have had no luck... Actually using variables for the cells, but simplified here for example's sake.

If Application.WorksheetFunction.Sum(Range(Cells(2, 2), Cells(123, 2))) = 0

 

[sricketts]

Thanks to all for the detailed explanations! It makes sense now. The following worked :

If WorksheetFunction.Sum(Range(Sheets("data").Cells(2, 2), Sheets("data").Cells(123, USE_COL))) = 0 Then

....off and running...!

 

[sricketts]

The "With" also worked. Just got the nuance of the .s in it, relative. Thanks again!