Excel VBA - convert a Range Address to a Range

I retrieve a range in this form, from a refEdit box on  a form.
"Sheet1!$E$15:$E$32"

I want to set that as a Range rngSource.

What's the syntax for that please?
hindersalivaAsked:
Who is Participating?
 
Subodh Tiwari (Neeraj)Excel & VBA ExpertCommented:
Try this...
Dim rng As Range
Set rng = Range("Sheet1!$E$15:$E$32")

Open in new window

0
 
Shaun VermaakTechnical Specialist/DeveloperCommented:
Is it not Range("Sheet1!E15:E32")?
0
 
hindersalivaAuthor Commented:
Ah. I thought I did that but I might have done something stupid and I thought it did not work!

Yes. It works.
Thanks!
0
 
Subodh Tiwari (Neeraj)Excel & VBA ExpertCommented:
You'r welcome!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.