I'm currently migrating VB6 app to .net which uses a lot of excel automation. the vb6 code employs a number of ranges and loops using a second range object as follows
For Each rngCell in rngFocus
< Do Stuff>
Next
This doesn't appear to work in .net, producing an Exception "Member Not Found"
Is there an easy way to convert all the loops. I know I can use "For i = 1 To rngFocus.Areas.Count" but this will be a pain to convert.
Thanks
Paul
For Each rngCell in rngFocus
< Do Stuff>
Next
This doesn't appear to work in .net, producing an Exception "Member Not Found"
Is there an easy way to convert all the loops. I know I can use "For i = 1 To rngFocus.Areas.Count" but this will be a pain to convert.
Thanks
Paul