Hi,
> Is there a paste option
For example:
https://www.google.com/search?q=excel+vbscript+copy+paste+data
And the whole Excel COM documentation.
I have some simple fixes using which you can easily delete blank rows in Excel.
1. Choose the data set > press Ctrl + F keys to open the Find and Replace dialog.
2. Hit the “Options” button > choose “Values” from “Look in” And let the “Find What” text box blank > click “Find All”.
3. Dialog box of “Find and Replace” will highlight entire blank cells.
4. Click any one record > press Ctrl + A for selecting the entire blank cells.
5. Close the dialog box of “Find and Replace” and without clicking anywhere else go to Home > Delete > Delete Rows.
6. Doing this will delete the entire selected rows.
For more tricks like this, check out this link.
source: www.repairmsexcel.com/blog/delete-blank-rows-in-excel
