TextToColumns

L

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.
 
G

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
 
Top