Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 1 of 1
03-13-2009, 10:32 AM #1
- Join Date
- Mar 2009
- Thanked 0 Times in 0 Posts
How do I extract values from a named range in excel?
I can see how to access a single value in a known location e.g.
var1 = Excel.Workbooks.ActiveSheet.Cells(1,1).Value;
how do I retrieve the values in a named range e.g. "MyRange" and assign them to variables?
I can retrieve the address of the range but cant see how that helps me to loop through the values in the range and assign them. I have played with for in statements to try a for each approach to the range but can't get that to work.
Any help appreciated.