Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Debug Error in Code
I have the following code which works fine when I import information into a
spreadsheet on my PC but which creates run time errors when replacing Overall Result with "" when used by someone else. I think we are working on different versions of Excel. Is there some modification of the code required for it to run in versions earlier than 2003? Private Sub Worksheet_Change(ByVal Target As Range) Columns("A:A").Select Selection.Replace What:="Overall Result", Replacement:="", LookAt:=xlPart _ , SearchOrder:=xlByColumns, MatchCase:=False, SearchFormat:=False, _ ReplaceFormat:=False Range("A65536").End(xlUp).Select ActiveCell.Offset(1, 0).Select Target.EntireColumn.AutoFit End Sub |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Debug Error in Code
Hi Karen
I've had similar problems when i was using a macro that originated from 2003 on XP. I removed the SearchFormat:=False part of the macro and it worked fine on both versions of excel. Hope this helps. "Karen McKenzie" wrote: I have the following code which works fine when I import information into a spreadsheet on my PC but which creates run time errors when replacing Overall Result with "" when used by someone else. I think we are working on different versions of Excel. Is there some modification of the code required for it to run in versions earlier than 2003? Private Sub Worksheet_Change(ByVal Target As Range) Columns("A:A").Select Selection.Replace What:="Overall Result", Replacement:="", LookAt:=xlPart _ , SearchOrder:=xlByColumns, MatchCase:=False, SearchFormat:=False, _ ReplaceFormat:=False Range("A65536").End(xlUp).Select ActiveCell.Offset(1, 0).Select Target.EntireColumn.AutoFit End Sub |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Debug Error in Code
Check your other post, too.
Karen McKenzie wrote: I have the following code which works fine when I import information into a spreadsheet on my PC but which creates run time errors when replacing Overall Result with "" when used by someone else. I think we are working on different versions of Excel. Is there some modification of the code required for it to run in versions earlier than 2003? Private Sub Worksheet_Change(ByVal Target As Range) Columns("A:A").Select Selection.Replace What:="Overall Result", Replacement:="", LookAt:=xlPart _ , SearchOrder:=xlByColumns, MatchCase:=False, SearchFormat:=False, _ ReplaceFormat:=False Range("A65536").End(xlUp).Select ActiveCell.Offset(1, 0).Select Target.EntireColumn.AutoFit End Sub -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
error in this code | Excel Worksheet Functions | |||
Code Error | Excel Discussion (Misc queries) | |||
How do I resolve debug error macro Excel 2000? At least, any lead | Excel Discussion (Misc queries) | |||
Error Code 481 | Excel Discussion (Misc queries) | |||
Code error ?? | Excel Discussion (Misc queries) |