Add a Blank row to a Office script that sorts several rows

Luis Mesquita 0 Reputation points
2024-08-22T14:13:55.51+00:00

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?

Thanks1000023492

Office Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
3,859 questions
Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,708 questions
0 comments No comments
{count} votes

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.