excel training onsite - Excel VBA

The UK's most regular instructor-led training courses.
Training information: excel training onsite · Microsoft+excel+training · VBA training in London

Resolved · Low Priority · Version Standard

Excel VBA

Adrian has attended:
No courses

by - delegate Adrian [2 posts] (2007 Sep 11 Tue, 15:55) Reply

At the beginning of a macro I want to set the ActiveCell to a cell containing a particular string of text. How can I do this. I have tried:

activesheet.find(string)

as the first line of the macro but to no avail. Any help much appreciated

Version	Date	Location	Places available	Book	Next place rate:
Excel Advanced 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2002/XP	2008 Sep 10 Wed	Tooting	0	FULL
2003	2008 Sep 10 Wed	Bloomsbury	5	book now	£219	£235
2003	2008 Sep 12 Fri	Southwark	5	book now	£219	£235
2003	2008 Sep 17 Wed	Southwark	0	FULL
2003	2008 Sep 17 Wed	Bayswater	5	book now	£195	£205
2003	2008 Sep 19 Fri	Bloomsbury	6	book now	£214	£230
Full Schedule: See all 125 Excel Advanced course dates. Bookings currently available until 24th November 2009.

RE: Excel VBA

by - delegate Vicky [3 posts] (2007 Sep 13 Thu, 13:53) Reply

Hi Adrian

A suggestion is:

Cells.Find("string").Activate

This should search the page you have selected and move to the cell containing the string.
Hope this helps.

RE: Excel VBA

by - delegate Adrian [2 posts] (2007 Sep 13 Thu, 16:25) Reply

Vicky,

Many thanks. There are days when I try to be intelligent. Yesterday was not one of them!

· Do You Really Need Excel VBA Training?
· Microsoft Excel Cheat Sheet: Tips and Shortcuts
· Reasons Why VBA for Excel Training Fails
· What's Better Than the Help Function in Excel? Microsoft Training
· Features of Microsoft Excel that assist in Analysis of Financial Data