Thread
:
Find cell contents in range
View Single Post
#
3
papou
Posts: n/a
Hello Nigel
Try this:
On Error Resume Next
Range("A1", Range("A65536").End(xlUp)).Find(Range("K12") _
..Value, , xlValues, xlWhole, xlByRows).Activate
If Err < 0 Then MsgBox "value not found"
HTH
Cordially
Pascal
"Nigel" a écrit dans le message de news:
...
Hi,
i am really struggling to create a macro to carry out the following.
( i am quite new to this and presently using a book but things are
explained
fully!)
lets say cell K12 = 2245
i have a range of A2:A50 containing a list between 2220 & 2270
i need my macro to look at the value of K12. Find that value in range, and
make the cell with that value active
so in my list between 2220 & 2270 is an activecell where the value is 2245
i hope this can be done and hope that someone can help me.
Regards,
Nigel
Reply With Quote