selecting multiple sheets

[Mars]

I am trying to define multiple sheets as an object that can be used within another calculation.

i started by defining xlWbk:

Set xlWbk = xlApp.ActiveWorkbook

then comes the line I'm having trouble with:

Set xlShtPrem = xlWbk.Sheets(Array("sheet1", "sheet2", "sheet3"))

I then want to use "xlshtprem" in the following formula

dCLEP6 = Sum(xlShtPrem.Cells(lRow, 13))

I'm trying to get the sum of those specific cells on each sheet.

What's wrong with the syntax I'm trying to use?

 

[Babydum]

Do you need code to do this? Is using a formula an option? something like:

=SUM(Sheet1:Sheet3!13:13)

 

[Mars]

I cant use a formula. This is all taking place inside a macro in Access.