Macro to expand range

I have bunch of spreadsheets with ranges of strings in this format - Annn:Annn, where A is a constant (can be any letter) and nnn is a 1 to 3 digit number. For example R3:R8 or C5:C112. These strings are always in the same spreadsheet column.

I need a macro that would expand these ranges to include all of the intermediate values, separated by commas and spaces. For example, R3:R8 should expand to R3, R4, R5, R6, R7, R8.

I'm guessing this would not be terribly difficult to do in a macro, but it is beyond my capabilities.

TIA

?

Please Login or Register  to view this content.