Building custom solutions that extend, automate, and integrate Microsoft 365 apps.
Add a Blank row to a Office script that sorts several rows
Hi,
I am not an experience user but I have recorded the script that sorts a range according to two conditions
first one is in column 15 believe in the code refers to index 14 , that column either has "Não" that should sort first and "sim" that should sort as last
this is that dynamic I keep changing this , the code below is working great, no issues but I want after the sorting to add a blank row between the last row with "não" and the first with "sim"
Perhaps in the screen shot attached is clear
Can someone help me add to the code a way to add such blank row?
Thanks
Microsoft 365 and Office | Development | Other
Microsoft 365 and Office | Excel | For business | Windows
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data