I know this is a vba forum, and I tried c# forum to find an answer, no luck. I tried to convert the following vba code into c# and couldn't make it work.
Sub aaa()
For Each ce In Sheet1.UsedRange
Set tester = Intersect(ce, Range("yournamerange"))
If tester Is Nothing Then MsgBox ce.Address & " is outside range"
Next ce
End Sub
foreach(Range r in sheet1.usedrange)
{
}
I get member not found error.
Does anyone know how to make it work?. I implemented the same with 2 for loops. but
Sub aaa()
For Each ce In Sheet1.UsedRange
Set tester = Intersect(ce, Range("yournamerange"))
If tester Is Nothing Then MsgBox ce.Address & " is outside range"
Next ce
End Sub
foreach(Range r in sheet1.usedrange)
{
}
I get member not found error.
Does anyone know how to make it work?. I implemented the same with 2 for loops. but