Hello Alec

Try setting the Worksheet in question to be the ActiveWorksheet. Do this

NameOfWorksheet.Activat

then call your WorksheetFunctio

Your Worksheet name may be an Object or ThisWorkbook.Worksheets("NameOfWorksheet"

Dee