98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » excel training onsite - Excel VBA
excel training onsite - Excel VBA
Resolved · Low Priority · Version Standard
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
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 tip:Selecting constant values onlyIf 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. |
