Hi Niek, thanks for writing back. The first arguement of an offset function
is a cell reference. I am trying to fill that arguement with the Address
function (because my cell reference is not always the same, I need a function
to describe it). Address does the trick except that the offset function
thinks of the result of the address functiona as "A1" (literally with the
quotes). But for offset to work properly and recognize the cell it has to be
A1 (no quotes). =offset(A1,...... not =offset("A1",....

If you want to see for yourself, nest Address in the first arguement of
offset then highlight the nested address function in the formula bar and hit
F9, you will see what I'm saying. Any help is appreciated!

"Niek Otten" wrote:

What are you trying to achieve?
What formula did you try (with what input values)?
What result did you expect and what did you get instead?

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Aaron" wrote in message ...
| Actually, I can't use mid, since that also returns text I still get quotes.
| I'm really stuck, how do I nest the result without the quotes??? Please help!
|
| "Aaron" wrote:
|
| For the reference syntax of my offset formula I am using the Address
| function. What I need is A1 but of course the Addres function returns "A1"
| which means nothing to the offset function. how do I get the address formula
| to just return A1? I suppose I could use MID, but is that the only way?