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
Bookmarks