vba courses london - 'Intelligent' navigation around worksheets

The UK's most regular instructor-led training courses.
Training information: vba courses london · Excel london

Resolved · Low Priority · Version Standard

'Intelligent' navigation around worksheets

Matt has attended:
Excel VBA course

by - delegate Matt [1 post] (2007 Feb 22 Thu, 09:55) Reply

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?

RE: 'Intelligent' navigation around worksheets

by - trainer Jacob silver contributer [89 posts] (2007 Mar 5 Mon, 12:08) Reply

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

· Company Roles in Visual Basic Training
· What Is Microsoft Excel VBA and How Can It Help You Work Smarter?

Vba tip:

Add A New Sheet at the end of the Workbook

To add a new sheet at the end of the workbook you need to count the sheets in the workbook using:

Sheets.Count

Then use this value as the rank of the sheet after which you want to add the new sheet:

Sheets.Add After:=Sheets(Sheets.Count)

View all VBA hints and tips