Auto fill worksheet cells based on values from a specified input range
wautofill irng:=[Book1]Sheet1!Col(1)[2]:Col(2)[4] orng:= [Book1]Sheet1!Col(1)[2]:Col(3)[6] action:=repeat;
Please refer to the page for additional option switches when accessing the x-function from script
Input
Range
Specified Input Range.
Output
Specified Output Range to fill See the syntax here.
int
This action list is to specify the fill action mode. Option list
Option list
This function is used to fill the Worksheet automatically.
We can only fill the cells automatically in the output range. If the output range max column index > input range max column index, it will fill horizontally. If the output range max row index > input range max row index, it will fill vertically. If both, then it will fill totally. Else it will not do anything.