Microsoft Office Forums - View Single Post - [Solved] Help with macros, what's wrong with my code??

cc.caroline15 · 01-12-2015, 07:25 PM

Hi,
What i'm trying to do is that when the user clicks the macro have a window pop up asking in what cell do you want to display the results of adding cells B6:E6 and end up with the active cell being the cell that is displaying the results. Please help me I'm so confuse my code is not working.
Thanks

Quote:

Originally Posted by whatsup

Hi

If I've got it right, you want to sumarize the last four cells to the left of the selected cell, that's how it works:

Code:

Sub Do_Sum()
With ActiveCell
    If .Column > 4 Then
        .FormulaR1C1 = "=Sum(RC[-4]:RC[-1])"
    End If
End With
End Sub

Cheers