Excel range in C#

[Jerry]

I am rewriting my vba routines to C# to increase speed. I have been unable to
find any help on how to pass ranges to C#.

Excel function that was called in VBA
=CalcRows(A1,A2,B1:B140,C1:C140,D1:D140)

A1 holds the type of calculation to perform
A2 holds the number of rows to calculate
B1:B140 column used in calculations (Dependent on what A1 has)
C1:C140 column used in calculations (Dependent on what A1 has)
D1:D140 columnused in calculation on B1:B140 or C1:C140
CalcRows would then return the total from the calculation.

In VBA I was able to declare a multi dimensional array as a parameter to
hold the three ranges. I have been unable to do this in C#. I reccieve a
#value error in just trying to use a multidimensional array. Ive even try to
use three spearate arrays without any luck.

How do I pass a range or ranges to C#?

[Patrick Altman]

Check out a previous post for some examples of the Excel object model:
http://msdn.microsoft.com/newsgroups...8a7&sloc=en-us

You'll essentially need to get Excel.Range objects from the Excel.Worksheet
object with a call to Excel.Worksheet.get_Range(string, string);

Hope that helps,
Patrick Altman
"Jerry" wrote:

I am rewriting my vba routines to C# to increase speed. I have been unable to
find any help on how to pass ranges to C#.

Excel function that was called in VBA
=CalcRows(A1,A2,B1:B140,C1:C140,D1:D140)

A1 holds the type of calculation to perform
A2 holds the number of rows to calculate
B1:B140 column used in calculations (Dependent on what A1 has)
C1:C140 column used in calculations (Dependent on what A1 has)
D1:D140 columnused in calculation on B1:B140 or C1:C140
CalcRows would then return the total from the calculation.

In VBA I was able to declare a multi dimensional array as a parameter to
hold the three ranges. I have been unable to do this in C#. I reccieve a
#value error in just trying to use a multidimensional array. Ive even try to
use three spearate arrays without any luck.

How do I pass a range or ranges to C#?

[Jerry]

I have figured out that I will need to use the Excel. Object property. THe
problem I am having now is how is the code written for something like this. I
am new to C# and have a few functions I am trying to convert. For instance
how would this be wrriten in C#

Excel cell =calctotal(5,A1:A8,B1:B8)

the five is how many rows to calculate even though more rows are sent.
I have been able to write a function to calculate when a single cell is
sent but when it comes to range I am having problems figuring this out.