Target Range Wanted

[AlexanderBB]

I need to get the Range object Target that is sent to the Worksheet Selection change event - from somewhere else.
If it's possible what needs to be known / done?

 

[Scott Huish]

If you're using it somewhere else, why can't you just use Selection in your code??

Otherwise, please provide more details about what you are trying to accomplish

 

[AlexanderBB]

Because it changes. I have a function that uses target for various things. I could multi-purpose use it if I can create another 'target'.

 

[Scott Huish]

Target is related to event code.
While you could assign this range to a public variable. It would change every time it is used. More info would be helpful

Target would change everytime you changed the selection in the Selection Change event.

I still don't understand why you can't use Selection and determine if that's in the range you want, just like you can do with Target.

For example, if you had some cells selected in Column A. This code would only color the background of the cells Red, while excluding anything selected outside of Column A.

Sub test()
Dim c As Range, d As Range
Set d = Intersect(Selection, Range("A:A"))
If d Is Nothing Then Exit Sub
For Each c In d
    c.Interior.Color = vbRed
Next
End Sub

or you could pass the Target range to another function or macro but without more details about what you are doing, I don't know how I can help further.

 

[Scott Huish]

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Call test(Target)
End Sub


Sub test(r As Range)
r.Interior.Color = vbRed
End Sub

This isn't very useful because it will color every cell you select red, but it shows how you could pass the value to another sub or function

 

[AlexanderBB]

I'll try and explain it a bit better... LOL but may just complicate it further.
In the worksheet SelectionChange I show details from target into the status bar.
Then in the d-click event I send Target into a Function. This populates another worksheet that becomes the row source for a listbox.
If the user selects a different entry the listbox, I want to show those (new) details in the status bar, replacing what was there
With Target for that new selection I can reuse the same function to populate the status bar.

 

[RoryA]

Target is just a Range variable. How does the entry in the listbox translate to a range?