Hello everyone!

This is my first post in the community!

I am using applescript to post process a bunch of data in Excel and i am facing a problem regarding autofill or fill down commands.

Lets say that i have a Column A filled with data and a column B where i put a formula to the cell B1. How can i autofill the rest of the column B and stop to the number of rows of adjacent column A?

I have tried to use:

fill down range “B:B” but it goes to down infinity and fills blank cells with zeros.

What i need is a sort of fill down range “B1:Bx” where x is the number of rows of column A. The length of column A varies from file to file. How do i do this?

Thanks for any help