Using Array for Sheet Names

hello,

i have names of sheets stored in Shno1, shno2,shno3 and so on. I would like to refer this in a for loop with increment variable (i) and the following code is either incorrect on logic / syntax. can i get the right one please.

Workbooks(firstfile).Sheets(shno(i)).UsedRange.Copy

Ex:
i have Sheetx, SheetY, SheetZ stored in variable shno1,shno2,shno3 respectively and i have to use the above code which should refer to these sheets.

Thanks.

sorry If iam missing something or not been clear on my earlier query

i have defined shno as array and stored the names of the sheets in it

Please Login or Register  to view this content.

Note: i have stored the sheetnames in D1,D2 etc..

my apologies again. Not sure if posting the entire code may be relevant. Hence I am redefining my query. If this helps it would be great else i will paste my complete code.

for instance if i have to refer to display values in D2 of all sheets and use Sheetnames to refer ( instead of referring to sheet1,sheet2 etc). how do i do that?
the one below would require change as it is not working

Please Login or Register  to view this content.

Thanks for your constant responses inspite of me not getting my query right. Let me add to what i had posted before

Sheetname Value in D2
Abc 50
bcd 100
cde 150
def 200

i have the sheet names stored in Shno1,shno2,shno3,shno4 as abc,bcd,cde,def respectively. when i run this code and when it loops every time should display 50 first [ refers to Sheet "Abc" as this is stored in shno(1), 100 second time ( refers to "Bcd" as this is stored in Shno(2), 150 third time and 200 on the final loop

Please Login or Register  to view this content.

Hope this is clear.