I have the following macro to send a copy of a worksheet as a workbook in an email. Was ok until it was noticed that the links had been removed from source file. Now they are re established the file created keeps referencing the link. I have tried getting it to paste value but cannot see why it will not do it. Am I missing something obvious
Please Login or Register to view this content.
Last edited by nigelog; 07-11-2016 at 11:50 AM.
Cell containing =today() does copy across as a value. Other cells reference index match value from another workbook. What is copied across is the iferror message wrapping the index match formula if the source file is missing. How can I paste across the visible cell value of these index matches. Any help appreciated.
This replaces the formulas with their current values.
Please Login or Register to view this content.
Surround your VBA code with CODE tags e.g.;
[CODE]your VBA code here[/CODE]
The # button in the forum editor will apply CODE tags around your selected text.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks