I am new to VBE. How can I create a for loop without typing it into

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?

JamesSnell
Fri Mar 14 09:21:00 CDT 2008

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

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


"dave186@gmail.com" 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?
>

jmbundy
Fri Mar 14 09:25:02 CDT 2008

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.


"dave186@gmail.com" 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?
>

Bob
Fri Mar 14 11:01:23 CDT 2008

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)



<dave186@gmail.com> wrote in message
news:b380d342-adb2-4e22-b3fc-207385f38fdd@s19g2000prg.googlegroups.com...
> 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?