What I have is a drop down menu, I want the input range to grow as I
add data to my table, without having to go back in and redefining the
range everytime.

It's telling me that my variable is not defined.

I very new to VBA, where am I going wrong?

Sub addrow()
bottom = Cells(65536, 23).End(xlUp).Row
Range("$W$19,bottom").Select
ActiveWorkbook.Names.Add Name:="enginetypes"
End Sub