Hi the code below does not give me an error message but does not do the job either? Any help would be appreciated.
Sub col_merge()
Dim x As Integer
Dim y As Integer
x = InputBox("first col#")
y = InputBox("second col#")
Workbooks(1).Worksheets(1).Columns("x:y").Merge
End Sub