Newbie: How to get another range?

[x-rays]

Hello All,

I want to write some vba code to get a range other than of the "Target"
one, suppose that I'm in Worksheet_SelectionChange or Worksheet_Change
event. How accomplish that?

Thanks in advance!

 

[NickHK]

What's the connection between the Target and the "other range" ?

Other wise, just use:
Range("A1").Value
or
Worksheets("SomeotherSheet").Range("A6:M45)

NickHK

 

[x-rays]

Thanks Nick, I just find out from another post.

Thank you very much for your reply!

 

[NickHK]

If you are going to post to more than one, relevant NG, then cross-post, not
multi-post.
Otherwise many people waste their time answering questions the OP has no
interest in reading, because the OP already has an answer elsewhere.

http://en.wikipedia.org/wiki/Cross-posting

NickHK