Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Find a cell in a specified range 1

Status
Not open for further replies.
lode

lode

Programmer
Nov 8, 2001
208
BE
Hi,

How can i find a cell in a specified range.
When the user changes a cell in the worksheet i need to know wether he changed a cell in the specified range or not.
I need this for the change-event of that worksheet.

Thanks

Lode.



 
Sort by date Sort by votes
From Help:

Worksheets("Sheet1").Activate
Set isect = Application.Intersect(Range("rg1"), Range("rg2"))
If isect Is Nothing Then
MsgBox "Ranges do not intersect"
Else
isect.Select
End If


HTH
Andrea
 
Upvote 0 Downvote
Hi aMember,

This is just what i'm looking for.
GREAT !!!!!
Thanks you very, very much !!

Best regards.

Lode.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

sal21
  • Locked
  • Question
scrping in listbox in a web page
Replies
0
Views
458
sal21
sal21
dgillz
  • Locked
  • Question
Back coloring an entire row if a duplicate is found in a dynamic range 1
Replies
18
Views
527
SkipVought
S
IcarusHallsorts
  • Locked
  • Question
I have a column of data in Column A
Replies
3
Views
352
Andrzejek
Andrzejek
Andrzejek
  • Question
Hyperlinks in Word cut at #
Replies
2
Views
190
Andrzejek
Andrzejek
kris gersbach
  • Locked
  • Question
I’m importing a csv into a vfp curs
Replies
1
Views
237
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top