Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 08-22-2016, 03:11 PM
AustinBrister AustinBrister is offline Take String of numbers, expand ranges, sort, then compress back into ranges Windows 7 64bit Take String of numbers, expand ranges, sort, then compress back into ranges Office 2013
Novice
Take String of numbers, expand ranges, sort, then compress back into ranges
 
Join Date: May 2015
Posts: 16
AustinBrister is on a distinguished road
Default

All:



Thank you so much for your help on all of this. Very helpful and interesting to see other people's much cleaner and more organized redo of my code. Much easier to understand what's going on.

I came across another question about this process.

What if I wanted to specify a range of numbers, say "20-30," that needed to be adjusted up or down by 1 or 2? In other words, once the numbers are expanded, correct all numbers within a defined range up or down by a specified amount (20 should become 22, 21 should become 23, and so on), and then proceed to sort and compress those numbers. Seems like this should be a fairly simple operation that could be inserted after the gmaxey's bubblesort expands the strSpanDelimiter, but I'm not sure where to add the operation.
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Take String of numbers, expand ranges, sort, then compress back into ranges Dynamic chart ranges GlowingApple Excel 1 02-17-2016 07:18 PM
Take String of numbers, expand ranges, sort, then compress back into ranges Problem with have a chart with different data ranges expert4knowledge Excel 2 09-09-2014 06:27 AM
Take String of numbers, expand ranges, sort, then compress back into ranges 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 09:46 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2026, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2026 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft