Adress of Copied Range

[Luis Carrion]

When you select a Range and Copy it, a moving border is created around
the selection. This "border" persists until you press Esc or set
Application.CutCopyMode=False in VBA.

If you click in other area of the sheet, it´ll still be blinking
around a previous copied range. How do I detect the address of the
moving border once I position inside other cell?

Thanks
LC

 

[Dave Peterson]

I don't think you can. But why do you want to?

If you copied the range in code, you'll know what you copied. If you just want
to paste the already copied cells, you can just paste to one cell and excel will
expand the "to" range to match the dimensions of the "from" range.