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