Import cell value to script Autofill
I am working on trying to automate the length of an autofill based on the value in cell C6. The cell C6 looks at row 9 and finds the last instance column where there is a value with the following formula
=SUBSTITUTE(ADDRESS(1,LOOKUP(1E+307,COLUMN(9:9)*IF(9:9=””,””,1)),4),”1″, “”)
Office Script Error: The button cannot run because the script was unshared. Contact the owner to share it again
To the Office Script team.