View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Paste non-adjacent cell content from Excel to open Word document

I'd paste an intermediate copy into a new worksheet. Then copy|Paste from there
into MSWord.

Jimbob wrote:

Hi

There are many posts here addressing this subject but my particular
requirement is to paste from Excel to an existing open Word template.
The Word filename will be variable. I will have the cursor positioned at the
insertion point in the Word template and want to Alt, Tab, select and paste
non-adjacent cells (known OFFSET is always 0, 11) from my Excel workbook and
paste as unformatted text into Word.

When I try this manually, I always get the intervening cell content as well
so Im guessing 2 copy/paste events are needed.

BTW, I€˜m using 2003.

Thanks in advance


--

Dave Peterson