Forum Discussion

Jamin's avatar
Jamin
Copper Contributor
Feb 14, 2025
Solved

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!

2 Replies

    • Jamin's avatar
      Jamin
      Copper Contributor

      Hi HansVogelaar 

      Thanks for pointing that out.
      I will try looking for an alternative approach.

Resources