Macro to add colums together in different worksheets

discodave

New Member
Joined
Mar 21, 2011
Messages
9
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
 

Some videos you may like

Excel Facts

How can you turn a range sideways?
Copy the range. Select a blank cell. Right-click, Paste Special, then choose Transpose.

mirabeau

Banned user
Joined
Nov 4, 2010
Messages
2,075
do you mean this sort of thing?
Code:
Sub addcol()
With Application
sumit = .Sum(Sheets("sheet1").Columns(2)) _
   + .Sum(Sheets("sheet2").Columns(1))
End With
MsgBox sumit
End Sub
 

Watch MrExcel Video

Forum statistics

Threads
1,108,632
Messages
5,523,994
Members
409,554
Latest member
denistrevisan

This Week's Hot Topics

Top