vba courses london - 'Intelligent' navigation around worksheets | VBA forum

Resolved · Low Priority · Version Standard

Thu 22 Feb 2007, 09:55 Delegate 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:08 Trainer 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 courses

	98.8 % recommend us
	More live stats...

Training information:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions
Popular forum topics

VBA tip:

Count the Rows and Columns in a Selection

If you need to count the number of rows or columns in a worksheet use the following code:

Selection.Rows.Count - Returns the number of rows in the selection

Selection.Columns.Count - Returns the number of columns in the selection

Selection.CurrentRegion.Rows.Count - Returns the number of rows in the current region of the selection

View all VBA hints and tips