Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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#? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Passing Excel NAMED Range to VBA | Excel Worksheet Functions | |||
Passing a range in a macro call | Excel Programming | |||
Passing range as an argument in a function | Excel Programming | |||
Passing range as argument | Excel Programming | |||
Passing range to subprocedure - maybe? | Excel Programming |