Retrieving Cut/Copy Border Address

[Joseph Mc Daid]

I am looking for a way to retrieve the address of the cut/copy border
in excel, but have had absolutely no joy browsing the forums and
excel's object model. If I've missed something obvious I apologise,
but any help would be appreciated at this stage.

Kind Regards,

Jose

[Leith Ross]

HelloJose,

To return the address of the cut/copy border, use Selection.Address.

Sincerely,
Leith Ross

[Joseph Mc Daid]

Dear Leith,

Selection.Address returns the current selection's address, which may
have changed since the user chose to copy the range. If my macro was
run directly after the user selected the copy range this may work,
however this is almost never going to be the case.

What i am ideally after is the address of the "moving border" copy box
that appears on screen when the user chooses to copy a range.

Regards,

Joseph Mc Daid

[Leith Ross]

Hello Joseph,

After looking deeper into what you want to do, I can say there are no easy methods to accomplish it. The easiest would be to monitor the cells being selected using the Worksheet_Change() event. The drawback being this has to be copied into every worksheet in the workbook that will be using this. The second and by far the most unattractive and complex would be to retrieve the cell addresses copied to the Clipboard. Once the user selects a different cell, the contents to be cut or copied are transfered to the clipboard, and Excel no longer has those addresses stored internally. Sorry the news isn't better.

Siincerely,
Leith Ross

[Joseph Mc Daid]

Dear Leith,

I am not averse to following the complex route, if there is come means
of accessing the source cell addresses by delving into the clipboard
contents then i shall investigate.

Off the top of my head i wouldn't think that the source address would
be stored in the clipboard, but i have no prior experience, so thats
just conjecture. Can you confirm that the source range is stored in the
clipboard? Any thoughts on API calls that you might know off the top of
your head that could be used to access the clipboard would be
appreciated. I suspect this is headache material so i apologise in
advance :-)

Kind Regards,

Joseph Mc Daid

[Leith Ross]

Hello Joseph,

I will look into the Clipboard API calls more, as my experience with them is limited. You may be correct about the addresses not be stored. The API calls only deal with "formats". So the addresses may be a moot point. I don't think hooking into the Windows messaging system via Subclassing would be a very viable option to "spy" on the CTRL + C or CTRL + X keys input. It is an interesting problem. I will let you know what I find.

Sincerely,
Leith Ross