View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Range Paste in VBA

Unless you move the data to the workbook and link the comboboxes to the
local range, there would be no command for that.

--
Regards,
Tom Ogilvy

"Tobie Hanekom" wrote in message
...
I am send an email from Excel with success, but the sheet attached to the
mail has objects on it with combo box lists on another sheet. This causes
the sheet attached to the mail being linked to the original workbook.

What code do one use to range paste the sheet which will "delete" the

links?

Tobie