Convert String to Row Range

Hi all,

I'm trying to convert a string into a range to select using the following:

Please Login or Register  to view this content.

The string produced is: strRange = Rolls("52:55")
Range(strRange).Select

Since in my code I'm using Rolls("1:6").select

I want to now select the fresulting rolls and shift them down like the following usage:

Please Login or Register  to view this content.

The code keeps erroring since something is not being addressed correctly
I've tried a few other ideas but, I think I've exhausted all my attemps.

NE hlp is appreciated.

Thanks,

BDB

Please Login or Register  to view this content.

or

Please Login or Register  to view this content.

Thanks for the reply RNB , but I didn't need a solution to resize rows 1- 6.
Anyways your post gave me an idea to try and it worked.

Please Login or Register  to view this content.

BTW, I didn't convert the address location to a string, I figured using the locations row was good enough.

Thanks again,

BDB