Hi Guys,
Here is my problem statement:
Suppose there are 2 multi-dimensional arrays in excel:
array 1: say range 1
a b
c d
array 2: say range 2
p q
r s
I can perform an addition of these 2 arrays using: {(range1) + (range2)} in excel to get the desired result...
But, the problem arises when I try and perform a similar thing in VBA. Although, using the "for" loops I can perform the said addition, but if I use a formula like:
Worksheets("Cust_Summ").Range(Cells(10, 2), Cells(13, 22)) = Worksheets("Cust_Summ").Range(Cells(10, 2), Cells(13, 22)) + Worksheets(a).Range(Cells(228, 13), Cells(231, 33))
It gives me an error. Is there an expert who can help me with this...I have to repeat this process across 20-25 worksheets and hence the complier will take a long time if I use the "for" loop method....
I want to know if we can perform range additions in VBA which would consume lesser time??
I hope the experts here will help me on this!!
Bookmarks