Hello,
I found a Youtube video from Bill Jelen (See title below) that replicates the AutoSum Function. I couldn't find a way to copy and paste the macro so I tried to write it myself. For some reason, I get an error when trying to run the code? I have searched through the code repeatedly but cannot find anything I am doing different than his original code. Do I have something wrong in this code below?
If this code doesn't work, is there another way to replicate the AutoSum Function?
I found a Youtube video from Bill Jelen (See title below) that replicates the AutoSum Function. I couldn't find a way to copy and paste the macro so I tried to write it myself. For some reason, I get an error when trying to run the code? I have searched through the code repeatedly but cannot find anything I am doing different than his original code. Do I have something wrong in this code below?
If this code doesn't work, is there another way to replicate the AutoSum Function?
Excel - Excel Macro Replicating AutoSum Functionality with a Single Line of Code - Episode 844
VBA Code:
Sub AutoSumAbove()
ActiveCell.Formula = "=SUM(" & Range(ActiveCell.Offset(-1, 0), ActiveCell.Offset(-1, 0).End(x1Up)).Address & ")"
End Sub
