Using Range (from Userform) as Variable

[ktennies]

Hello,

I have a userform where I want users to place a letter in one text box to reference a column and a number in another textbox to reference a row. I'm trying to concatenate the values of the two textboxes to create a range which I can define as a variable.

If I use this code everything works fine:

Please Login or Register  to view this content.

But I can't seem to create a variable from the same code. Say I just want name a variable to select the cell... this code isn't working:

Please Login or Register  to view this content.

Any thoughts?

[TMS]

Use "Set":

Please Login or Register  to view this content.

Regards, TMS

[ktennies]

I had actually tried that previously, but I was working with the Dim statement and must not have had it set as a range at that point. I was so close! In any case, it's working now.

Thanks for your help TMS!

[TMS]

You're welcome.