Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Do you want to replace the contents of
When my macro runs, it stops after this procdure and asks "Do you want to
replace the contents ofthe destination cells" is there something I can add that will automatically tell it yes? Here is the part of the macro that it stops on. Selection.TextToColumns Destination:=Range("C1"), DataType:=xlDelimited, _ TextQualifier:=xlDoubleQuote, ConsecutiveDelimiter:=False, Tab:=False, _ Semicolon:=False, Comma:=False, Space:=False, Other:=True, OtherChar _ :="/", FieldInfo:=Array(Array(1, 1), Array(2, 1), Array(3, 1)) Thanks |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Do you want to replace the contents of
Hi,
Try inserting this line just above the problem: Application.DisplayAlerts = False You should restore this later in the code with the line: Application.DisplayAlerts = True Regards - Dave. "Donna" wrote: When my macro runs, it stops after this procdure and asks "Do you want to replace the contents ofthe destination cells" is there something I can add that will automatically tell it yes? Here is the part of the macro that it stops on. Selection.TextToColumns Destination:=Range("C1"), DataType:=xlDelimited, _ TextQualifier:=xlDoubleQuote, ConsecutiveDelimiter:=False, Tab:=False, _ Semicolon:=False, Comma:=False, Space:=False, Other:=True, OtherChar _ :="/", FieldInfo:=Array(Array(1, 1), Array(2, 1), Array(3, 1)) Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Replace #VALUE! with contents of cell?? | Excel Worksheet Functions | |||
use replace command to change the contents of formulas | Excel Discussion (Misc queries) | |||
Find and Replace Hyperlink Contents | Excel Discussion (Misc queries) | |||
replace cell contents | Excel Worksheet Functions | |||
How do I replace the contents of a cell with its value instead of. | Excel Worksheet Functions |