Retrieving the address of a cell in a range

[Coleman34]

I am trying to retrieve the address of a cell in a selected range so it can be compared to the current input. If they are the same, the Loop is broken and the code moves on. (If GetFullAddress = GetDefaultCell then exit loop as below

Please Login or Register  to view this content.

The ranges chosen by the user are limitless, so this check helps end the loop:

GetFullAddress is working perfectly:

Please Login or Register  to view this content.

But no matter how hard I try I cannot get the variable firstCell to read anything other than "1", which is the cell value. I tried reading the address into a string ( firstCellString = CStr(UserRanges.Item(UserRanges.Count).Cells(1, 1).Address) ) and converting it to a range (firstCell = Range(firstCellString)). In this case firstCellString returns "$A$1" but when i pass it through the second step firstCell = 1. I need first cell to be $A$1 help?

Please Login or Register  to view this content.

[6StringJazzer]

First of all, GetFullAddress is not working perfectly. It is missing the closing ' . It should be

Please Login or Register  to view this content.

Second, it's difficult to understand what you're really trying to do based on your description but I think you're getting tangled up trying to extract an address as a string, convert it to a Range, then somehow get a string back out of that. This is the code you really want:

Please Login or Register  to view this content.

[Coleman34]

That worked, I had assumed it was the GetDefaultCell when all along it was the GetFullAddress...I'm glad I put that up there. I would have banged my head against that for hours.