I need some help with code i am writing for work. My boss throws this project on me knowing i have no knowledge in Visual Basic or any code at all. LOL....so i have to basically teach myself but i am to the point where im lost.

I have this sheet of data, and what i need the macro/code to do is to scan each row of the first column and do so until it reaches/finds a value of 100. When and if it finds the value of 100, i need a message box to pop up stating what row the value is in. This is phase 1 of a 3 phase project, and i know i can do this manually by counting, but it has to be inputted into a machine that does the technical work the code will generate.

I know this is probably a very simple thing, but i have the Excel 2007 VBA programmers reference, but this whole code thing isnt my thing. But my boss just will not listen.....so i am here asking for any help i can get.

Thanks in advance!!

Here you have it

Sub Find_A_Text()

Dim MyRange As Range
Set MyRange = Range("A:A").Find("100", , xlValues, xlPart)

If Not MyRange Is Nothing Then
    MsgBox MyRange.Row
End If

End Sub


If you are looking for gettting all instances of the Text Try the following

http://vbadud.blogspot.com/2007/10/e...ll-method.html

Cheers
Shasur

http://www.dotnetdud.blogspot.com

VBA Tips & Tricks (http://www.vbadud.blogspot.com)

thank you sir, i really appreciate it!!