Hello:
I have a column of values or values that contain range addresses and I'm trying to find the ideal method to convert a string that contains the range address to a range object so that I can loop down the column and do something with each range object. Here's an example of the string/value in cell(2,5) = Summary!$A$2:$AH$52. I tried various parsing approaches and thought perhaps there's an easier way. Thanks for any help.
Zachary
Bookmarks