I have written a macro to find the last blank cell in col F also then to total the sales value which is in column F but my code fails.
My code is as follows:
My code is as follows:
Code:
Range("F8").Select
Selection.End(xlDown).Offset(1, 0).Select
MyRow = ActiveCell.Select
ActiveCell.FormulaR1C1 = "=SUM(R[-" & MyRow & " C:R[-1]C)"
Could you please help
Regards