ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   passing range to c# (https://www.excelbanter.com/excel-programming/321949-passing-range-c.html)

Jerry

passing range to c#
 
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#?



All times are GMT +1. The time now is 11:47 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com