Forum Discussion
Jamin
Feb 14, 2025Copper Contributor
How to access temp selection?
Hi, is there a way to determine the temporary selection address from vba?
The steps to reproduce are as follows:
Select cells [A1:A3].
Hold the right mouse button and drag the selection and move to A10, now release the right mouse button and I have a temporary drag and drop area of [A1:A10].
However it is not the current selection (the result from Application.Selection is still "A1:A3")
Thanks you!
As far as I know, this is not exposed to the programmer in VBA.
2 Replies
As far as I know, this is not exposed to the programmer in VBA.
- JaminCopper Contributor
Hi HansVogelaar
Thanks for pointing that out.
I will try looking for an alternative approach.