Results 1 to 9 of 9

Replace old ticker symbols

Threaded View

worswick25 Replace old ticker symbols 09-08-2011, 06:48 AM
NBVC Re: Replace old ticker symbols 09-08-2011, 07:53 AM
worswick25 Re: Replace old ticker symbols 09-08-2011, 08:19 AM
martindwilson Re: Replace old ticker symbols 09-10-2011, 02:11 PM
worswick25 Re: Replace old ticker symbols 09-12-2011, 02:33 PM
martindwilson Re: Replace old ticker symbols 09-13-2011, 06:24 PM
worswick25 Re: Replace old ticker symbols 09-14-2011, 05:34 AM
martindwilson Re: Replace old ticker symbols 09-14-2011, 08:28 AM
worswick25 Re: Replace old ticker symbols 09-14-2011, 01:29 PM
  1. #1
    Registered User
    Join Date
    09-08-2011
    Location
    BOLTON
    MS-Off Ver
    Excel 2003
    Posts
    66

    Replace old ticker symbols

    Hi

    On Excel 2000 spreadsheets
    I wish to replace about 90 old ticker symbols to the new ticker symbols on the Excel spreadsheets

    The macro below works ok.
    Changing from old ticker "0P00000CCO" to new ticker "PKACC"

    How do I copy and repeat the Macro below for
    90 different old ticker symbols to 90 different new ticker symbols

    All the old ticker symbols are in the same column

    --------------------------------------------------------------------------------------------------------------------------------

    Sub Macro1()
    '
    ' Macro1 Macro
    ' Macro recorded 08/09/2011 by
    '
    ' Keyboard Shortcut: Ctrl+Shift+Q
    '
    Cells.Find(What:="0P00000CCO", After:=ActiveCell, LookIn:=xlFormulas, _
    LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, _
    MatchCase:=False).Activate
    ActiveCell.Replace What:="0P00000CCO", Replacement:="PKACC", LookAt:= _
    xlPart, SearchOrder:=xlByRows, MatchCase:=False


    End Sub
    --------------------------------------------------------------------------------------------------------------------------------

    Hoping you can oblige

    Derek Worswick
    Last edited by worswick25; 09-15-2011 at 01:19 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1