When I change selectio in a worksheet, the range that I select is passed to
the SelectionChange event as Target. How can I identify the range that I have
changed from?
When I change selectio in a worksheet, the range that I select is passed to
the SelectionChange event as Target. How can I identify the range that I have
changed from?
You would need to put in a static variable in the selectionchange event and
update it as you exit the selectionchange event.
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Dim oldSelection as Static
' code that does things
set OldSelection = Target
End Sub
if you will have to use this value on the very first selectionchange, then
you will need to make it a public variable in a general module and
initialize it in the Workbook_Open event.
--
Regards,
Tom Ogilvy
"Hayeso" <[email protected]> wrote in message
news:[email protected]...
> When I change selectio in a worksheet, the range that I select is passed
to
> the SelectionChange event as Target. How can I identify the range that I
have
> changed from?
Thanks Tom, That makes sense.
"Tom Ogilvy" wrote:
> You would need to put in a static variable in the selectionchange event and
> update it as you exit the selectionchange event.
>
> Private Sub Worksheet_SelectionChange(ByVal Target As Range)
> Dim oldSelection as Static
>
> ' code that does things
>
>
> set OldSelection = Target
>
> End Sub
>
> if you will have to use this value on the very first selectionchange, then
> you will need to make it a public variable in a general module and
> initialize it in the Workbook_Open event.
>
> --
> Regards,
> Tom Ogilvy
>
>
> "Hayeso" <[email protected]> wrote in message
> news:[email protected]...
> > When I change selectio in a worksheet, the range that I select is passed
> to
> > the SelectionChange event as Target. How can I identify the range that I
> have
> > changed from?
>
>
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks