[RESOLVED] Find all Cells in a Range in Excel

[thekeane]

I'm trying to dynamically create a table of results using the solver "By changing cells" information. If you use a the SolverGet function you can get a string that contains all of the cells that the user had selected.

I have parsed the string down to begin to create the table but was wondering if there is an easier way to get a list of all the cells in a range.

For example the user enters

Sheet1!B2:C3, Sheet1!D6, Sheet1!E5

So is there an easy way to find out that B2:C3 is really B2,B3,C2,C3 so I can put that as a column header.

Thanks

[VBAhack]

This might help:

Sub ParseInput(ParamArray arglist() As Variant)
Dim arg As Variant
Dim i As Integer
Dim txt As String
For Each arg In arglist
For i = 1 To arg.Cells.Count
txt = arg(i).Address
'blah, blah, blah
Next i
Next arg
End Sub

[thekeane]

Thanks, just what i was looking for. Modified it a little bit to use a two dimensional array, but pointed me in the right direction.