 |
 | 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 / New Users / July 2006loop on criteria
hi all, i would like to do a loop on criteria list in order to use it for a comperasion for access file, what is the best way to do it? Maybe For Each cell in Range("Criteria") 'do something Next cell which assumes that the criteria is a named range  SignatureHTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) > hi all, > i would like to do a loop on criteria list in order to use it for a > comperasion for access file, > what is the best way to do it? hi Bob thank you for the answer i didnt understand so much how can implement it the issue is that i need to use the criteria in order to compare with another office tool access now in order to do this i need to take the value of the criteria. do you have an idea how can i do it? Bob Phillips כתב: > Maybe > [quoted text clipped - 15 lines] > > comperasion for access file, > > what is the best way to do it? Not enough info to work on I am afraid. SignatureHTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) hi Bob thank you for the answer i didnt understand so much how can implement it the issue is that i need to use the criteria in order to compare with another office tool access now in order to do this i need to take the value of the criteria. do you have an idea how can i do it? Bob Phillips ???: > Maybe > [quoted text clipped - 17 lines] > > comperasion for access file, > > what is the best way to do it?
|
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.