Relative macros : Two Queries

[lrollo]

Excel 2002

Q1:: When I attempt to record a macro, the I don't see the
macro 'toolbar' that should hang in the Excel window. It was there but
now does not appear.

I've looked in View/Toolbars but there is no entry for this item.

How does one restore this 'toolbar'?

Reloading Excel has not solved the problem.

Q2:: Excel Recorded Relative Macro with Search Function

When I could record a macro, I made recorded relative macro to
capture a sting value in a source cell, move to another worksheet, and
search for the string, with a number of actions to follow, with the
cursor finally coming to rest in the cell below the original start
cell, ready to be repeated.

In the recorded macro code below, the Find string persists and
prevents the macro from using a subsequent find value.

Is there a simple way of clearing the find value after it was
located the target cell, so that the string value of the next source
cell will be recorded to carry out the succeeding search?

ActiveCell.Select
Selection.Copy
ActiveSheet.Next.Select
ActiveSheet.Next.Select
Cells.Find(What:="13AE8V", After:=ActiveCell, LookIn:=xlFormulas,
LookAt _
:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext,
MatchCase:= _
False, SearchFormat:=False).Activate
ActiveCell.Offset(0, 12).Range("A1").Select
ActiveSheet.Previous.Select
ActiveSheet.Previous.Select
ActiveCell.Offset(0, 11).Range("A1").Select
< remainder of code follows>



Lindsay Rollo
Wellington, New Zealand

 

[Bob Phillips]

Start recording another macro, then goto Tools>Customise and select the
Toolbars tab, then check the Stop Recording checkbox


And don't close it by hitting the "X" when recording a macro or you will
lose it again.


--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[lrollo]

"Bob Phillips":

Tks for solution,



Lindsay Rollo
Wellington, New Zealand