Archive of Mr Excel Message Board

Back to Forms in Excel VBA archive index
Back to archive home

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 ?

Check out our Excel Resources

Re: a self modifying formula

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

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

Re: a self modifying formula

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

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.