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?

Microsoft OfficeVBAMicrosoft ExcelMicrosoft Applications

Last Comment

Subodh Tiwari (Neeraj)

8/22/2022 - Mon

ASKER CERTIFIED SOLUTION

Subodh Tiwari (Neeraj)

3/30/2018

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

See Pricing Options

Start Free Trial

GET A PERSONALIZED SOLUTION

Ask your own question & get feedback from real experts

Find out why thousands trust the EE community with their toughest problems.

SOLUTION

Shaun Vermaak

3/30/2018

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

See Pricing Options

Start Free Trial

GET A PERSONALIZED SOLUTION

Ask your own question & get feedback from real experts

Find out why thousands trust the EE community with their toughest problems.

hindersaliva

3/30/2018

ASKER

Ah. I thought I did that but I might have done something stupid and I thought it did not work!

Yes. It works.
Thanks!

Subodh Tiwari (Neeraj)

3/30/2018

You'r welcome!

Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!

Certified Expert Program

Credly Partnership

Udemy Partnership