TextToColumns

[Luis Rentería]

Hi!

How can I avoid confirming if I wish or not to replace destination cells
while I use Text to Columns function?

It really doesn't matter if the contents of those cells is lost.

Thanks in advance.

 

[Don Guillett]

application.displayalerts=false
reset to true after

 

[Gord Dibben]

Luis

This would have to be done through VBA code.

Sub Text_To_Col()
Application.DisplayAlerts = False
''Record your Data>Text to Columns steps here
Application.DisplayAlerts = True
End Sub

Gord Dibben Excel MVP