Range Paste in VBA

  • Thread starter Thread starter Tobie Hanekom
  • Start date Start date
T

Tobie Hanekom

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
 
Unless you move the data to the workbook and link the comboboxes to the
local range, there would be no command for that.
 
You must log in or register to reply here.

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

Similar Threads

Copy/Paste and remove blanks VBA 0
Run macro from active workbook whose name keeps changing 20
Copy columns and paste with blank column between 5
VBA code for pasting links -- modifying RDB code for summary workbook 10
Code execution is correct but generates Error :The file you aretrying to open is in a different form 3
VBA: Paste in a range 6
Copy ranges from several sheets to another one in a vertical position 1
Copy worksheet, trying to paste to new workbook error assistance. 1

Back
Top