Trying to store a range into a cell

Hi Guys,

I have a userform which requests the user to select several ranges through refedit boxes (several on the same userform).

As far as I understood, these refedit boxes return a string. I used range(Refedit1.Value) to get the range & store it in a range variable, which all works perfectly.

However, I would like to store the range in a cell on an excel worksheet, in order to be able to restore this value to the refedit box when the user opens it again (through the initialize procedure).

But when I try to save the string to my worksheets, nothing happens in the worksheet, the userform closes and excel crashes when I load it again.
F.e:

Please Login or Register  to view this content.

What am I doing wrong?

Thx