Error in my VBA code for putting sum total of column A in cell A1

[kettler]

I'm trying to learn some VBA and in my testing/learning, I'm trying to put the sum total of col A in cell A1 and with this below code Im able to get my answer.

Range("A1") = WorksheetFunction.Sum(Range("A:A"))

However, Im trying to tweak the code such that the data should only check from cell A2 to the last data cell in col A (dynamic - as my no of rows can change) even if there are blank/emply cells or null value cells in between. And using this code, I'm getting an error (see bottom). Any recommendations? Btw this is the only code in my subroutine.

Range("A1") = WorksheetFunction.Sum(Range("A2:A" & lastrow))

Thank you for your suggestions.

 

[Fluff]

What is LastRow?

 

[Marc L]

Without any useless variable as a beginner starter :​

    [A1].Value2 = Application.Sum(Range("A2", Cells(Rows.Count, 1).End(xlUp)))

 

[kettler]

@Fluff - trying to get to the last data cell in the column.

@Marc L - yes that worked very well. Thank you for your input. I learnt something new in VBA today.