No replies to this topic

[ahkuan]

I'm novice in vb. I struggle of thinking how to add two range of data in excel by VBA. I had tried many times but still cant make it work.

sub testing()
dim a,b,c as range

set a = range("A1:A3")
set b= range("B1:B3")

c = range("C1:C3")
c = a + b
end sub

Please help me on this.

Edited by Jaan, 07 July 2009 - 04:02 PM.
Please use code tags when you are posting your codes!