Target Address Property for Insert/Delete Row/Column
 

Target.Cells(1,1)

--
__________________________________
HTH

Bob

"Excel Monkey" wrote in message
...
When I select call A1, the address property of the target is "$A$1". When
I
select A1 and then hit Delete/Insert Rows/Column, the target is set to
$1:$1.
However A1 is still selected visually (i.e. row 1 is not highlighted). I
am
assuming that this is Excel's way of addressing where to insert/delete the
new range.

I need to find a way of referencing what the single cell address was prior
to excel changing it. Any ideas

Thanks

EM