Macro to add colums together in different worksheets

[discodave]

hi

im struggling to make a macro which,
adds all the values in one colum on a worksheet, to the values in a colum in a different worksheet.
(hope that makes sense)

if anyone could help me out, id be really appreciated
thanks

 

[mirabeau]

do you mean this sort of thing?

Sub addcol()
With Application
sumit = .Sum(Sheets("sheet1").Columns(2)) _
   + .Sum(Sheets("sheet2").Columns(1))
End With
MsgBox sumit
End Sub

 

[discodave]

yeah i think so,