excel training onsite - Excel VBA

Resolved · Low Priority · Version Standard

Tue 11 Sep 2007, 15:55 Delegate Adrian said...

Adrian has attended:
No courses

Excel VBA

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

Thu 13 Sep 2007, 13:53 Delegate Vicky said...

RE: Excel VBA

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.

Thu 13 Sep 2007, 16:25 Delegate Adrian said...

RE: Excel VBA

Vicky,

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

Training courses

	98.7 % recommend us
	More live stats...

Training information:

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

Excel tip:

Selecting constant values only

If periodically you need to change all your values back to zero, but leave formulas, text and blank cells as they are select the entire worksheet, choose F5 function key, Special and then Constants and choose the appropriate sub-selections. To enter zero in all the selected cells type 0 and then press Ctrl+Enter.

View all Excel hints and tips