Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro to sum doesn't work
I have numbers in Column G and Column I. I want to add the numbers and have
the results display in Column J. Like so: G I J 2 2 4 5 3 8 1 9 10 I have set up a macro that does several things to the worksheet, and I want it to automatically add the numbers. The number of row changes each time the macro is run, which is once a week or so. Here is the code I have in the macro, but it doesn't work. It adds all the numbers in Column G to all the numbers in Column I which is not what i want. What am I doing wrong? With ActiveSheet lastrow = .Cells(.Rows.Count, "a").End(xlUp).Row For i = 2 To lastrow If IsNumeric(.Cells(i, "j").Value2) Then .Cells(i, "j").Value2 = "=sum(g:g,i:i)" End If Next i End With Thanks for any and all help |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro to sum doesn't work
Try the below
Sub MyMacro() Dim lngRow As Long lngRow = Cells(Rows.Count, "I").End(xlUp).Row Range("J2:J" & lngRow).Formula = "=G2+I2" End Sub -- Jacob "RM270" wrote: I have numbers in Column G and Column I. I want to add the numbers and have the results display in Column J. Like so: G I J 2 2 4 5 3 8 1 9 10 I have set up a macro that does several things to the worksheet, and I want it to automatically add the numbers. The number of row changes each time the macro is run, which is once a week or so. Here is the code I have in the macro, but it doesn't work. It adds all the numbers in Column G to all the numbers in Column I which is not what i want. What am I doing wrong? With ActiveSheet lastrow = .Cells(.Rows.Count, "a").End(xlUp).Row For i = 2 To lastrow If IsNumeric(.Cells(i, "j").Value2) Then .Cells(i, "j").Value2 = "=sum(g:g,i:i)" End If Next i End With Thanks for any and all help |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro to sum doesn't work
Thank you so much Jacob. Works perfectly.
"Jacob Skaria" wrote: Try the below Sub MyMacro() Dim lngRow As Long lngRow = Cells(Rows.Count, "I").End(xlUp).Row Range("J2:J" & lngRow).Formula = "=G2+I2" End Sub -- Jacob "RM270" wrote: I have numbers in Column G and Column I. I want to add the numbers and have the results display in Column J. Like so: G I J 2 2 4 5 3 8 1 9 10 I have set up a macro that does several things to the worksheet, and I want it to automatically add the numbers. The number of row changes each time the macro is run, which is once a week or so. Here is the code I have in the macro, but it doesn't work. It adds all the numbers in Column G to all the numbers in Column I which is not what i want. What am I doing wrong? With ActiveSheet lastrow = .Cells(.Rows.Count, "a").End(xlUp).Row For i = 2 To lastrow If IsNumeric(.Cells(i, "j").Value2) Then .Cells(i, "j").Value2 = "=sum(g:g,i:i)" End If Next i End With Thanks for any and all help |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro will not work - Please help | Excel Discussion (Misc queries) | |||
Macro to update a column in a work based on another work sheet | New Users to Excel | |||
Macro works Macro does not work | Excel Discussion (Misc queries) | |||
Why Won't This Macro Work? | Excel Discussion (Misc queries) | |||
how to get a macro to work | Excel Discussion (Misc queries) |