I made a sheet with a column containing a dropdown (which I now can't
find to change, but it still drops and allows selection) which has a
list of destinations. When a destination is chosen, code populates the
next column with the mileage from my house to the target.

When I cleared out last years mileages, I somehow disconnected the
code, and it no longer fires.

When I try to run it from the VBA editor, it wants a macro name.

Any suggestions for hooking it back up? I've probably described this
poorly. Can you tell I'm a newbie?

TIA, Mike