About Us

Karen53

Thank you, OssieMac!

"OssieMac" wrote:

Hi Karen,

Now I understand a little better. The use of the CELL function is correct
for the circumstances and it is returning information as I said it should. In
this case it is returning the filename.

Now your specific problem is the worksheet name with the space. Because of
the space you need to enclose it in single quotes not double quotes.

=CELL("filename",'Day One'!$A$1)

Regards,

OssieMac

"Karen53" wrote:

I am trying to follow these instructions, unsuccessfully. I am in Excel, not
VB.

http://www.ozgrid.com/Excel/variable...heet-names.htm

Thanks

"Karen53" wrote:

Hello,

I have been trying to get this to work.

=CELL("filename",Sheet1!$A$1)

I have an existing worksheet with multiple tabs. I want to create a named
range of worksheet names for a sequential portion of these tabs.

If I try it exacly as it says, I get a value not available error, probably
because I do not have a sheet named Sheet1.

If I try to replace Sheet1 with the name of my first worksheet for this
named range, Excel asks me where I want to save it.

=CELL("filename",Day One!$A$1)

If I add double single quotes, I get a formula error message.

=CELL("filename",''Day One''!$A$1)

What am I missing?

Also, once this is working, I would like it to pickup any newly added
worksheets within this range of worksheets and add the name to my named range
of worksheet names. Is this possible?

Thanks for your help.

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
creating a variable for file names	BEAST	Excel Discussion (Misc queries)	2	May 12th 07 09:39 PM
Variable names for named range	Barb Reinhardt	Excel Discussion (Misc queries)	4	March 19th 07 05:37 PM
variable file names	Brettjg	Excel Discussion (Misc queries)	2	March 2nd 07 10:56 AM
Variable Names in Formulas	Paulo	Excel Discussion (Misc queries)	2	March 29th 06 01:16 PM
are variable table-array names in functions possible?	JimH	Excel Discussion (Misc queries)	2	April 7th 05 09:51 PM

Menu

About Us