I wrote the following code. I am running a query through power query. Selecting the data. Copying it as values. And then Selecting the blank cells and trying to delete the the entire row.
Bit I am getting the error on the last line of code. "Selection.EntireRow.delete"
Error - Delete method of Range has failed.
Following is the code:-