Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
This is my macro, it goes column by column A - AZ delimiting text. The
problem I have is that I get an error message on the first column which is empty. After column A, is there a way to say if B1 is null, end macro before moving on to delimit Text in Column B? I want to make this macro available to other users but the error message is a problem. Columns("A:A").Select Selection.TextToColumns Destination:=Range("A1"), DataType:=xlDelimited, _ TextQualifier:=xlDoubleQuote, ConsecutiveDelimiter:=False, Tab:=True, _ Semicolon:=False, Comma:=False, Space:=False, Other:=False, FieldInfo _ :=Array(1, 1), TrailingMinusNumbers:=True Columns("B:B").Select Selection.TextToColumns Destination:=Range("B1"), DataType:=xlDelimited, _ TextQualifier:=xlDoubleQuote, ConsecutiveDelimiter:=False, Tab:=True, _ Semicolon:=False, Comma:=False, Space:=False, Other:=False, FieldInfo _ :=Array(1, 1), TrailingMinusNumbers:=True -- Sincerely, Beverly76 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Copy/paste from other application without delimiting it? | Excel Discussion (Misc queries) | |||
tab delimiting numbers | Excel Discussion (Misc queries) | |||
Delimiting and Formatting | Excel Discussion (Misc queries) | |||
delimiting w/multiple delimiters? | Excel Discussion (Misc queries) | |||
Pasting from clipboard-how to control text-to-columns delimiting | Excel Discussion (Misc queries) |