98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft VBA Training and help » vba courses london - 'Intelligent' navigation around worksheets | VBA forum
vba courses london - 'Intelligent' navigation around worksheets | VBA forum
Resolved · Low Priority · Version Standard
Thu 22 Feb 2007, 09:55Delegate Matt said...
Matt has attended:
Excel VBA Intro Intermediate course
'Intelligent' navigation around worksheets
I want to make macros find data in a style more like a human user would do.
How do I get a macro to navigate around a worksheet to find certain values? Are there useful tools / commands I can use to select cells based on location, properties or formatting rather than the value?
Mon 5 Mar 2007, 12:08Trainer Jacob said...
RE: 'Intelligent' navigation around worksheets
HI Matt
Further to your query, it looks like you are trying to build in funtionality which would be realistically addressed by having the assistance of a trainer/consultant.
We would need to agree a scope of work, features, and duration. If you are interested in us assisting in this way please let me know.
Regards
Jacob
Training information:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
VBA tip:Count the Rows and Columns in a SelectionIf you need to count the number of rows or columns in a worksheet use the following code: |
