Dynamic Objects in vba

[therenjithr]

I have multiple workbooks and worksheets and I need to create multiple objects for the same. Number of sheets are not finite but I want to use all objects at different scenarios. I tried to create dynamic objects but didn't help. Please suggest.

 

[Norie]

Why do you need a variable for each worksheet?

You can access all the worksheets in a workbook via its Worksheets/Sheets collection?

 

[Sektor]

You could keep references (variables) to those workbooks, but you don't need to keep references to sheets of those workbooks since you could easily get them: wkb.Sheets("MySheet").