VBA Filldown or Autofill

**jstuart2022** · 07-06-2022, 07:54 PM

Hello!

I've Frankensteined the excelgeocodingtool.com spreadsheet for work and added another sheet to give me the trip duration and kilometres. My issue is that I have to manually fill down the relevant formula everytime which isn't super user friendly for my colleagues.

I've tried

Please Login or Register  to view this content.

but I'm getting an error saying that the $ sign is invalid.

Is there a way that I can get the formula to fill down using VBA without including the formula in the code, or is there something else I should try?

Thank you

**6StringJazzer** · 07-06-2022, 08:41 PM

Try

Please Login or Register  to view this content.

**jstuart2022** · 07-07-2022, 02:47 AM

Hmm I can't seem to get that to work.

I've attached a copy of my spreadsheet with some random addresses (nothing personal) to hopefully help with the problem solving!