Excel vba search
15 November 2002, 10:32 AM
#1
Scooby Regular
Thread Starter
Join Date: Dec 1999
Posts: 2,221
Likes: 0
Received 0 Likes
on
0 Posts
Driving myself mad now.
After selecting a column I need to search for an exact number, eg 37. Not 6379 like its picking up at the moment. How can I make it select the cell with only the value I am looking for.
With the macro I'm using I'm unable to sort.
I know its a pants question but I'm going round in circles now.
After selecting a column I need to search for an exact number, eg 37. Not 6379 like its picking up at the moment. How can I make it select the cell with only the value I am looking for.
With the macro I'm using I'm unable to sort.
I know its a pants question but I'm going round in circles now.
15 November 2002, 10:48 AM
#2
Scooby Regular
Thread Starter
Join Date: Dec 1999
Posts: 2,221
Likes: 0
Received 0 Likes
on
0 Posts
Got it!
Selection.Find(What:="7", After:=ActiveCell, LookIn:=xlValues, LookAt:=xlWhole, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:=False).Activate
The power of Scoobynet ....
Selection.Find(What:="7", After:=ActiveCell, LookIn:=xlValues, LookAt:=xlWhole, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:=False).Activate
The power of Scoobynet ....
Thread
Thread Starter
Forum
Replies
Last Post
Mattybr5@MB Developments
Full Cars Breaking For Spares
28
28 December 2015 11:07 PM
Mattybr5@MB Developments
Full Cars Breaking For Spares
12
18 November 2015 07:03 AM