undo Absolute Cell References

Howdy, again:

I'm using a lot of "activeCell.offset(row,col).address" type of entries to form formulas for me. All of the references come across as Absolute References - $G$24, for example. Is there a different way for activeCell to give me a "normal" address ('G24' vice '$g$24') or a function that will convert for me?

Any ideas?

TIA.

Bob

Hello Bob,

The Address property takes 2 optional Boolean arguments for Row and Column. Setting both to False will return a relative reference address (no dollar signs).

Please Login or Register  to view this content.