Take String of numbers, expand ranges, sort, then compress back into ranges

		Microsoft Office Forums > Microsoft Word > Word VBA
Take String of numbers, expand ranges, sort, then compress back into ranges

FAQ

Thread Tools

Display Modes

#12

07-21-2016, 04:34 PM

gmaxey

Windows 7 32bit Take String of numbers, expand ranges, sort, then compress back into ranges

Office 2010 (Version 14.0)

Expert

Join Date: May 2010

Location: Brasstown, NC

Posts: 1,602

Andrew,

I'm dealing with that at the start:
strNumberList = fcnKillWhiteSpace(Selection.Text)

... which probably should include en and em spaces just to be complete.

__________________
Greg Maxey
Please visit my web site at http://www.gregmaxey.com/

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Dynamic chart ranges	GlowingApple	Excel	1	02-17-2016 07:18 PM
Problem with have a chart with different data ranges	expert4knowledge	Excel	2	09-09-2014 06:27 AM
Compare content of two ranges INCLUDING FORMATTING	delasson	Word VBA	3	12-10-2012 03:54 AM
How to use named ranges in excel vba?	bosve73	Excel Programming	4	01-25-2012 09:26 AM
Dynamic Named Ranges using text	hannu	Excel	0	06-22-2010 04:42 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:08 PM.