View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
NickHK NickHK is offline
external usenet poster
 
Posts: 4,391
Default Newbie: How to get another range?

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" wrote in message
oups.com...
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!