Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » excel training onsite - Excel VBA
|
|
|
The UK's most regular 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. |
excel training onsite - Excel VBA
Resolved · Low Priority · Version Standard
Reply Tue 11 Sep 2007, 15:55Delegate 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
For upcoming training course dates see: Pricing & availability
Reply Thu 13 Sep 2007, 13:53Delegate 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.
Reply Thu 13 Sep 2007, 16:25Delegate Adrian said...
RE: Excel VBA
Vicky,
Many thanks. There are days when I try to be intelligent. Yesterday was not one of them!
|
|