Posted to microsoft.public.excel.programming

Alexander[_4_] Alexander[_4_] is offline

external usenet poster

Posts: 6

Name define

I can not define the name with relative refference. I remember that I
created (long time ago) something as:

MyName
=Sheet1!Offset(-2,0)

Now I can't (returns error). Only if I write:
=Sheet1!Offset(G10,-2,0)
but am sure that I didn't work on that way before.

Any hit about that?

Tnx in advance,

Alex

Reply With Quote

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

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Define a Value	sagenichole	Excel Worksheet Functions	2	May 18th 10 02:41 PM
Define Name	rml	Excel Worksheet Functions	5	November 9th 06 01:33 PM
Define name	digicat	Excel Discussion (Misc queries)	6	January 19th 06 05:54 PM
Define name Q	Benjamin	Excel Discussion (Misc queries)	3	October 19th 05 01:29 PM
define name	sunshine	Excel Discussion (Misc queries)	1	March 29th 05 01:37 AM

All times are GMT +1. The time now is 09:46 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us