Lou

Use the index

Worksheets(1)
Worksheets(2)

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
DTHIS
www.nickhodge.co.uk


"LouP" wrote in message
...
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

Hi Nick,

Thanks for responding. Please see my further explanation below. Let me
know if what I am trying to do is still not clear.

Thanks Again,
Lou

"Nick Hodge" wrote:

Lou

Use the index

Worksheets(1)
Worksheets(2)

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
DTHIS
www.nickhodge.co.uk


"LouP" wrote in message
...
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

Lou

What is wrong with the solution I gave? This will always reference the two
far-left sheets

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
DTHIS
www.nickhodge.co.uk


"LouP" wrote in message
...
Hi Nick,

Thanks for responding. Please see my further explanation below. Let me
know if what I am trying to do is still not clear.

Thanks Again,
Lou

"Nick Hodge" wrote:

Lou

Use the index

Worksheets(1)
Worksheets(2)

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
DTHIS
www.nickhodge.co.uk


"LouP" wrote in message
...
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