View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ron de Bruin Ron de Bruin is offline
external usenet poster
 
Posts: 11,123
Default Paste Special MS Excel Worksheet range selection into Outlook Task

See your other thread

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Bugman" wrote in message ...
I am trying to paste an Excel range selection into an MS Outlook Task body
using code. This can be done manually with a Copy of the range selection and
then a Paste Special into the Task body as a Microsoft Office Excel
Worksheet. The Paste Special allows me to keep the Excel cells format, cell
shading, and the cell grid. Also, if I have some columns hidden can the copy
and paste be done of just the visible columns and not the hidden ones?

I've seen code to copy and paste normal text, but it doesn't keep the Excel
cell format.
Mucho Thanks.