LinkBack URL
About LinkBacks
Hello,
How does the following code have to be modified to paste only the values?
Kind regards
Please Login or Register to view this content.
AmicusA
Hello,
How does the following code have to be modified to paste only the values?
Kind regardsPlease Login or Register to view this content.
AmicusA
This should do it:
Please Login or Register to view this content.
Hi,
This codeproduces an error message:Please Login or Register to view this content.
"Compile error
Invalid or unqualified reference"
Regards
AmicusA
Update: I have noticed that I had put a "." between PasteSpecial and xlPasteValues, but if I delete it, I still get the same error message.
Last edited by AmicusA; 01-08-2018 at 11:07 AM.
Check sheetnames because the code written by Dave works just fine for me.
Did you put a space between PasteSpecial and xlPasteValues ?
Last edited by bakerman2; 01-08-2018 at 11:41 AM.
Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.
You need to show more of the code.
You only supplied 2 lines of code, I had to supply something in order for the code to work.
Hi,
Here is the whole Sub:
Before the DELETE section I have putPlease Login or Register to view this content.an after itPlease Login or Register to view this content.because the sub jumped to a function that has nothing to do with the present code, but it still jumps to it after the last DELETEPlease Login or Register to view this content.
Regards
AmicusA
Attaching a sample workbook enables others to work on your problem:
To attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include BEFORE/AFTER sheets if needed to show the process you're trying to complete or automate. Remember to desensitize the data.
Click on GO ADVANCED and click "manage attachments" to open the upload window.
To add a file to a post
..and it jumps also to "Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range)" where there is a For...Next where it works for some time.
It is very complicated to make a sample file in this case, but I'll try to do so.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
,
Bookmarks