Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro for expanding a range
Hi,
I have ranges of numbers which are inconsistent and random; by this i mean there is no logical order. I have separated the numbers using a dash i.e (45678 - 45688) I want excel to expand the range so that it displays 45678, 45679, 45680, etc up to 45688. The ranges are all in one cell however there is hundreds of cells all with different ranges. Some of the ranges are split up by single numbers to give an example ( 45678 - 45688; 45690; 45693 - 45699) it is important i only get the ranges separated by dashes not the entire range. I would like excel to convert the range and expand it into the same cell as the single numbers with a preference for numerical ordering Any help or assistance is greatly appreciated; i don't want to write this out by hand if possible. Ian |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Expanding Range in Formula? | Excel Discussion (Misc queries) | |||
Expanding a named range | Excel Programming | |||
Expanding a range | Excel Programming | |||
expanding a range of numbers | Excel Discussion (Misc queries) | |||
Auto expanding Range | Excel Programming |