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?