use sheets(1) or sheets(2) to select those two sheets, they will always
be the first two sheets in the workbook, or name them something, like
"Data 1" and "Data 2" and then refer to them that way, Sheets("Data
1").select

Sheets("Data 2").select



On Dec 18, 3:31 pm, LouP wrote:
I am trying to write a macro that always references the first two sheets and
I am adding new sheets daily to the workbook. I am naming the sheets with
the date they were added to the workbook. Is there a way to reference the
sheets that are always on the first two tabs? Remember that new tabs are
being added daily and I can't use Sheet1 as the newest sheet is given the
last number regardless of the tab order.

Lou