Range(Cells(i,j),Cells(k,j)) reference

[MICHAEL PEMBERTON]

I cannot seem to find a thread on this issue.  I use this code:

sheetname.Range(Cells(n,m),Cells(e,m)) to calculate a sum in VBA. But the same reference does not work in VB.net. 

How do I refer to the row, column (as integers) in a range in VB.net?

[Kedar Kulkarni]

may be something like this ws.Range(ws.Cells(row, col), ws.Cells(row1, row2))

(I am c# dev - it uses [ ] brackets)

[MICHAEL PEMBERTON]

Thank you Kedar.  But I think I've about given up on it.  The functions all run so slowly in the dll that I've just reverted to Excel macros.

--
You received this message because you are subscribed to the Google Groups "Excel-DNA" group.
To unsubscribe from this group and stop receiving emails from it, send an email to exceldna+u...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/exceldna/323e6725-5253-443c-a69a-521ee0c1fd2bn%40googlegroups.com.