Transferring a dynamically named string variable to another string variable.

Hi, this is a complex one to explain but I'll try. (Also hampers googling!)

I have six spreadsheets with names, I need to loop through these spreadsheets in order to clear the contents before I then insert some new data.

I need the [Active_Sheet = "Sheet_" & iSheet] line to transfer the *contents* of the variable (for example: "Sheet_3") to Active_Sheet, rather than the name of the variable it currently does.

Please Login or Register  to view this content.

Thoughts?

Thanks!

Right, after reading through this forum I stumbled across the answer! An array!

http://www.mrexcel.com/forum/excel-q...ble-names.html

Thanks, yes.

I found my perseverance of reading rather than googling!