how to convert a string (D10 : E 20) to a range object?
C#
2
Posts
1
Posters
0
Views
1
Watching
-
I could to convert a range object to a string, this way: string selectedRange = resRange.get_Address(false, false, XlReferenceStyle.xlA1, false, false); Now, how can I get back the range object from the string('selecteedRange' whose value is say "D10:E20")??? thanks.
-
I could to convert a range object to a string, this way: string selectedRange = resRange.get_Address(false, false, XlReferenceStyle.xlA1, false, false); Now, how can I get back the range object from the string('selecteedRange' whose value is say "D10:E20")??? thanks.
oh, no one responded yet, anywayz, i got it myself... here's what i've done: string []s = selectedRange.Split(new char[]{':'}); Range res = ((Worksheet)MyApplication.ActiveSheet).get_Range(s[0], s[1]); Regards.