Why is this a Run-time error 424 - Object Required?

[vbaNumpty]

I'm sure this is something super simple, but I can't figure it out.

Dim addMe As Range
Dim dashB As Worksheet

Set dashB = Sheet1


Set addMe = dashB.Cells(dashB.Rows.Count, "A").End(xlUp).Offset(1).Row

setting the addMe is giving the error.

 

[Fluff]

You need to get rid of the .Row as you have declared addMe as a Range.

 

[vbaNumpty]

You need to get rid of the .Row as you have declared addMe as a Range.

Always coming in to save the day. Thanks Fluff

 

[Fluff]

You're welcome & thanks for the feedback.