How to unhighlight pasted data

[Piglette]

I have some VBS code that pastes a block of data into an invisible Excel 2007 spreadsheet, activates a particular cell, saves and quits.

When the user opens the spreadsheet, they see the pasted data highlighted.

How to use VBS to get rid of the highlight before saving?

Thanks

Lukas

[HansV]

The Activate method doesn't change the selection, but makes a particular cell within the selection the active cell. You could use the Select method instead of the Activate method to reduce the selection to that particular cell.

[Piglette]

Thanks!