Try this

Target(2).Address

Hope this helps / Lars-Åke


On Sat, 12 Dec 2009 16:11:15 -0700, "Robert Crandal"
wrote:

Yes, that works excellent. Just what I was looking for.

BTW, what would be the correct notation to just extract a SINGLE
address? For example, what if I am only interested in the second
cell address in the list??

thankx again


"Lars-Åke Aspelin" wrote in message
.. .

Try this:

Private Sub Worksheet_Change(ByVal Target As Range)
For Each c In Target
nextaddress = c.Address
Next c
End Sub