Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Still trying to call the textToColumns wizard. The
documented argument list is: destination_ref, data_type, text_delim, consecutive_delim, tab, semicolon, comma, space, other, other_char, field_info Get "No data was selected to parse" message when executing code below. Could be the field_info, although I'm not really sure what they are looking for there. Thanks for any ideas. Public Sub textToColumnsWiz() With Application.Dialogs(xlDialogTextToColumns) rc = .Show(Range("H19"), xlDelimited, xlDoubleQuote, False, False, False, True, False, False, Array(1, 2, 3)) End With End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
IF - more than seven arguments | Excel Worksheet Functions | |||
Arguments | Excel Discussion (Misc queries) | |||
IF-more than 7 arguments in | Excel Worksheet Functions | |||
And, if, arguments.... | Excel Worksheet Functions | |||
arguments | Excel Discussion (Misc queries) |