Hi all,

Using Excel 2013 64-bit
As I am looping and loading a sheet array I could like to get a cell value from one of the sheets to use as the filename when I export to pdf

I tried
Sheets(avSheetsExport(1)).Select
sFileName = ActiveSheet.Range("A1")
I confirmed the LBound and UBound of the array are 1 and 3 respectively
Debug.Print LBound(avSheetsExport)
Debug.Print UBound(avSheetsExport)
The error I receive
Run-time error 9 - Subscript out of range
What else can I check?

thanks
w