Hello,

I've been trying to use the code for the individual worksheet for the
selection change:

Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range)

Here is a small piece of the code

Set mc1 = Selection
MsgBox mc1.Address(RowAbsolute:=True, columnabsolute:=True,
ReferenceStyle:=xlR1C1)

My problem is that I want to get the address of the selection before the
user hits enter. Is there a way to do this?

Thanks in advance for any help that you can offer.

A