Sheet referencing in a macro
 

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

Sheet referencing in a macro
 

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

Sheet referencing in a macro
 

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