Thanks for your help Rick. I added a little more detail under Pete's reply. I
hope I clarrified things better.

Joe


"Rick Rothstein (MVP - VB)" wrote:

This code...

ActiveWorkbook.ActiveSheet.Name

will return to the active worksheet name in the active workbook (just assign
it or concatenate it or whatever as needed). Is that what you were looking
for?

Rick


"Joe Gieder" wrote in message
...
First, thank you for your help.
I created a macro that is used with many different workbooks and I use the
worksheet name as criteria for one of the formulas. Is there a way to add
some code that will get the worksheet name of the open workbook and put it
into a formula or function? My workbooks contain varying amounts of
worksheets, one workbook has two sheets another has four and another has
12.
Some of the names of the sheets begin with the word summary, these sheets
I
don't include in my formula. Right now I go into my macro and manually
change
the criteria but this sometimes a long time. Can something like this be
done?

TIA
Joe