datastudent
Board Regular
- Joined
- Sep 7, 2021
- Messages
- 87
- Office Version
- 365
- Platform
- Windows
Hi,
How do I automatically answer OK on my pop?
Here is the action that triggers the pop up message.
.Columns("B:B").TextToColumns Destination:=Range("B1"), DataType:=xlDelimited, _
TextQualifier:=xlDoubleQuote, ConsecutiveDelimiter:=False, Tab:=True, _
Semicolon:=False, Comma:=True, Space:=False, Other:=False, FieldInfo _
:=Array(1, 1), TrailingMinusNumbers:=True
How do I automatically answer OK on my pop?
Here is the action that triggers the pop up message.
.Columns("B:B").TextToColumns Destination:=Range("B1"), DataType:=xlDelimited, _
TextQualifier:=xlDoubleQuote, ConsecutiveDelimiter:=False, Tab:=True, _
Semicolon:=False, Comma:=True, Space:=False, Other:=False, FieldInfo _
:=Array(1, 1), TrailingMinusNumbers:=True