 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Programming / March 2008I am new to VBE. How can I create a for loop without typing it into the code.
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. :) > 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.  Signature-John Please rate when your question is answered to help us and others know what is helpful. > 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. Signature--- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) > 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 to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.