Trying to Copy Data into Last Row of Table-PasteSpecial Values. Compile Error showing up

**nathan82** · 12-07-2020, 03:39 PM

I have no idea what is wrong with the code-I've used the PasteSpecial function in exactly the same way as I have before, but it is giving me a "Compile Error: Expected: End of Statement". Help please! I bolded the line that isn't functioning properly.

Please Login or Register  to view this content.

**Fluff13** · 12-07-2020, 04:30 PM

You need to get rid of the " _" after Copy.
If you are using pastespecial it must be separate from the copy line.

**nathan82** · 12-07-2020, 04:56 PM

Thank you! I'm kicking myself because it's so simple!

**Fluff13** · 12-07-2020, 04:57 PM

Glad to help & thanks for the feedback.

Trying to Copy Data into Last Row of Table-PasteSpecial Values. Compile Error showing up

LinkBack

Thread Tools

Rate This Thread

Display

Trying to Copy Data into Last Row of Table-PasteSpecial Values. Compile Error showing up

Re: Trying to Copy Data into Last Row of Table-PasteSpecial Values. Compile Error showing

Re: Trying to Copy Data into Last Row of Table-PasteSpecial Values. Compile Error showing

Re: Trying to Copy Data into Last Row of Table-PasteSpecial Values. Compile Error showing

Thread Information

Users Browsing this Thread

Similar Threads

Copy Data outside Excel and PasteSpecial inside Worksheet - Run-time error '1004'

[SOLVED] My pivot table is not showing the same values as the source data

[SOLVED] compile error with selection.pastespecial code

[SOLVED] Copying Values (Error PasteSpecial method)

Copy pasteSpecial Values after rngCopy

showing compile error

Showing chart as percentage but data table as values

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions