Uipath VBA How to put inside marco to excute

Hi is a new Excel file with no marco writen yet
I want to paste this script into my module vba

Sub FormatCells()
Columns(1).Select
Application.DisplayAlerts = False
With Range(Selection.Cells, Selection.Cells.End(xlDown))
.TextToColumns Destination:=Range(“A1”), DataType:=xlFixedWidth, _
FieldInfo:=Array(Array(0, 1), Array(9, 1), Array(20, 1), Array(32, 1), Array(39, 1), _
Array(47, 1), Array(50, 1), Array(56, 1), Array(57, 1), Array(63, 1), Array(71, 1), Array( _
77, 1), Array(86, 1), Array(92, 1), Array(101, 1), Array(107, 1), Array(116, 1), Array(122, _
1)), TrailingMinusNumbers:=True
End With
End Sub

How can i do it
CheckingCompany.xlsx (161.6 KB)

Solved :slight_smile:

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.