ok, thanks for explaining that. i have tried appending the counter value and
had no luck.

i have it working, it's just if i move sheets to the beginning, i have to
edit code to get the correct sheets selected. i am just using the sheet
reference location, for example, the 3rd sheet in the workbook, but if i
move a sheet in front, it is now the 4th sheet in the workbook and i have to
change a variable to get the correct sheet. i was looking for a way so it
didn't matter where the sheets were. they are listed in vb as sheet2 thru
sheet13, so i thought i would try that.

these are monthly sheets, jan thru dec. where i run into a problem is, i go
to the monthly sheet but always return to the summary sheet to paste and add
the results.
in the loop the activesheet always has to change..

that's why i am trying to use the sheet and number scheme. if i can't, it's
not a big deal, like i said, it works ok right now.


thanks for helping
--


Gary


wrote in message
oups.com...
Hi Gary,

Yeah when you use the Sheets(" ") notation like so it is in effect
asking for the tab name. When you want to select Sheet2 do you mean
where it says in the VBE Sheet2 or do you mean the second tab?

For the tab location, just use:
Dim CntE as Integer
Sheets(CntE).select

When selecting sheets by code name you just use
Sheet1.select 'no reference to the worksheets collection
Although I have had problems with how to select it using your counter.

James