Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / August 2007

Tip: Looking for answers? Try searching our database.

Relative macros : Two Queries

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
lrollo@paradise.net.nz - 08 Aug 2007 22:54 GMT
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 - 08 Aug 2007 23:30 GMT
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.

Signature

HTH

Bob

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

> Excel 2002
>
[quoted text clipped - 40 lines]
> Lindsay Rollo
> Wellington, New Zealand
lrollo@paradise.net.nz - 09 Aug 2007 01:44 GMT
"Bob Phillips":

    Tks for solution,

Lindsay Rollo
Wellington, New Zealand

Rate this thread:






 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.