AppleScript Paste Special with Skip Blanks problem

O

orliotis

Version: 2004
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

I'm trying to paste data from one worksheet into another using AppleScript. The trick is that the pasted data has some blank columns mixed in, and the destination worksheet has formulas in those same columns. I need to paste the data so it doesn't erase the formulas.

When I do this manually using the Paste Special dialog box (with the Skip Blanks option selected), it works perfectly. When I try to do the same using AppleScript, the empty columns are pasted and all the formulas are erased.

Here's the AppleScript I'm using for the paste:
paste special range "A1" with skip blanks

I've tried it in both Excel 2004 and Excel 2008 and get the same results with both.

Does anyone know how to get Skip Blanks to work correctly using AppleScript?

Thanks,
Brian
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top