Find Exact Number with Excel VBA

jcoat

New Member
Joined
Aug 8, 2014
Messages
4
So I'm doing a simple search replace

Code:
anode = 123
With Range(Columns(5), Columns(5))
     Set C = .Find(What:=anode, SearchFormat:=False)
     C.Value = newvalue
End With

How do I set my find so that I only return cells valued "123" not "1123" or "1239"?

Thanks
 

Some videos you may like

Excel Facts

How to create a cell-sized chart?
Tiny charts, called Sparklines, were added to Excel 2010. Look for Sparklines on the Insert tab.

Watch MrExcel Video

Forum statistics

Threads
1,108,960
Messages
5,525,911
Members
409,671
Latest member
nasseralateek

This Week's Hot Topics

Top