Results 1 to 2 of 2

quotes causing error

Threaded View

  1. #1
    Registered User
    Join Date
    05-15-2008
    Posts
    9

    quotes causing error

    Hello!

    I have created a macro to change some errors in our system.

    This line is causing the debugger to start:
    Cells.Replace What:="Lesson Quiz: ""Robin Hood""", Replacement:="Lesson Quiz: ""Robin Hood and Allen-a-Dale" / "Fair Rosamond""", LookAt:=xlPart, _
    SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
    ReplaceFormat:=True

    Which should look like this in the final spreadsheet:
    Lesson Quiz: "Robin Hood and Allen-a-Dale"/"Fair Rosamond"

    Can anyone help me figure out how to get this formatted correctly so that excel will run it?

    Thank you!

    David
    Last edited by dftf; 09-02-2009 at 03:49 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