Adding multi dimensional array/range in VBA.

[amitgaja007]

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:

Please Login or Register  to view this content.

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!!

[DonkeyOte]

please always encase VBA within CODE tags - even single line commands - I've edited your post for you on this occasion.

Perhaps...

Please Login or Register  to view this content.

[amitgaja007]

Thanks a ton problem soved!!
Your nick should be: "smartfox" instead of "donkeyote"

[snb]

If the ranges are in the same sheet:

Please Login or Register  to view this content.