Thread: I am new to VBE. How can I create a for loop without typing it intothe code.
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
James Snell James Snell is offline
external usenet poster
  
Posts: 46
Default I am new to VBE. How can I create a for loop without typing it in
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?

Reply With QuoteReply With Quote