a self modifying formula

Posted by Bill on October 01, 1999 10:40 AM

I want to write a formula that would use the contents of a cell as an address within itself.

Example: copy the contenets of A:C1,C14 to
?:C1,C14 using A:A1 as the location of ?

Posted by Confused on October 01, 1999 12:37 PM

Is this a riddle, or just a question that makes no sense?

Posted by Ivan Moala on October 02, 1999 3:22 AM

Example: copy the contenets of A:C1,C14 to

Bill, if you could elaborate more, then maybe
I can help, at first glance you could do it
using a combination of =ADDRESS(A1,B1,4,1)
& Row() plus Column()
But I'm not sure of your criteria ??

Ivan