Let's say I have a column with the number 1-100. I want to scan thru
each number until I hit the number 70. Is there a graphical way to do
this or must I know how the VBA syntax and type it in the code?

You'll be looking for the built in VLookup function then.

You can look up the syntax and examples in Excel help. :)


" wrote:

Let's say I have a column with the number 1-100. I want to scan thru
each number until I hit the number 70. Is there a graphical way to do
this or must I know how the VBA syntax and type it in the code?

If i understand, you want to find the first 70 that occurs in a column? I'm
not sure what you mean by a graphical way, but one way without code is to
just select the column, ctl F and type the number you want to find. If this
isn't what you're looking for, give us a better idea of what you need, who
will use it, and what for and that should help us help you.
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


" wrote:

Let's say I have a column with the number 1-100. I want to scan thru
each number until I hit the number 70. Is there a graphical way to do
this or must I know how the VBA syntax and type it in the code?

Use Find (Ctrl-F) in Excel with the macro recorder switched on.

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



wrote in message
...
Let's say I have a column with the number 1-100. I want to scan thru
each number until I hit the number 70. Is there a graphical way to do
this or must I know how the VBA syntax and type it in the code?