Set myRange to a cell value

[ChristineJ]

I'd like to adjust this line of code so that rather typing in the range of cells in the VBA, the range of cells comes from the value in cell G5.

Set myRange = Range("A1, B3, K12, L2:L6")

Cell G5 contains the value A1, B3, K12, L2:L6, (with a comma at the end)

This does not work, but something to this effect: Set myRange = Range("G5").Value (plus add quotes and remove last comma...)

Thanks!

 

[Fluff]

How about

Set myRange = Range(Left(Range("G5").Value, Len(Range("G5").Value) - 1))

 

[ChristineJ]

How about

Set myRange = Range(Left(Range("G5").Value, Len(Range("G5").Value) - 1))

Works perfectly! Thanks for the help.

 

[Fluff]

You're welcome & thanks for the feedback.