Thread
:
Problems with protected worksheet and macros
View Single Post
07-20-2017, 03:11 PM
NoSparks
Windows 7 64bit
Office 2010 64bit
Excel Hobbyist
Join Date: Nov 2013
Location: British Columbia, Canada
Posts: 842
The text to column dialogue has a check box next to the delimiter choices that is
Treat consecutive delimiters as one
When checked it adds
ConsecutiveDelimiter:=True
into the line of code.
NoSparks
View Public Profile
Find all posts by NoSparks