lior03
07-23-2006, 12:58 PM
hello
i am trying to cosolidate by using this code.......
With Worksheets("mmm").Activate
Range("A1").Consolidate _
Sources:=Array("hosen!R1C1:R37C6", "matnas!R1C1:R37C6"), _
Function:=xlSum, toprow:=True, leftcolumn:=True, createlinks:=True
End With
can anyone help fix it?
thanks
i am trying to cosolidate by using this code.......
With Worksheets("mmm").Activate
Range("A1").Consolidate _
Sources:=Array("hosen!R1C1:R37C6", "matnas!R1C1:R37C6"), _
Function:=xlSum, toprow:=True, leftcolumn:=True, createlinks:=True
End With
can anyone help fix it?
thanks