trying to adjust VBA that Autofills values down through empty cells until next filled cell

Hi everyone ,

I'm hoping to adjust this VBA that Auto-fills values down through empty cells until next data filled cell to run on multiple columns..

Right now , it works great (as you'll see if you test the macro in the worksheet) , but it only works with column "A". So currently the way I use it is I paste the data onto this macro enabled 'helper' file (attached below) , then I run the macro, then copy and past the new data back into the actual excel file I'm working on. And then I do it for the next column etc..

Basically, I'm trying to find a better workflow, so I'd like to get this macro to work on at least the first few columns, OR ideally , 20 or 30 columns (not sure if that's even possible thought?) . Any help would be greatly appreciated.

xlsm worksheet with current macro:
_forum example_VBA_Autofill cell values down through empty cells until next data-filled cell.xlsm

thanks xladept , but I just tried changing it to "A1:K" and ran it , and it filled in all blank areas with "#REF!"