VBA Clipboard Paste Values syntax

[yankeesrus07]

Hi everyone,

The attached tool I have is a part of a larger tool, but is independent in its function.

What it does: takes the input from a system (shown as 10 - Salaried, for example) and strips it of everything but the number (input in E22 and output in C22). It works great manually using Paste - Match Destination Formatting (taking the clipboard contents from my website and pasting from there), but I'm now looking to automate that process.

Paste from CPS should aim to take the clipboard contents (which works when pasted manually) and paste into E22:E145 (however many entries there are). Once that pastes over, Copy Class #s copies the values from C22:C145 and pastes in another sheet (this button currently works).

The issue I'm having is the VBA code associated with the Paste from CPS button. I have the following code implemented, but there is a debug error that I'm unsure how to proceed with. Error code is "Run-time error '1004': PasteSpecial method of Range class failed"

For testing: This command works if it's in Excel (copying I22:J23), from my website (if pasted manually), but not if pasted automatically from the website (ideal). So, not sure what's happening there.

Is there some limitation to VBA here that I'm missing (still getting used to syntax and flow here) or is there another piece to this puzzle in order to paste from the clipboard to emulate the manual paste command?

Any help here would be greatly appreciated! Thank you!

[stnkynts]

The code itself if fine as pasting data from the clipboard will work. The issue is probably with the source as you have already indicated.

[yankeesrus07]

Thanks for your response.

I would imagine it would be the source, then. Was just surprised because a manual paste command spits out the clipboard contents. Not sure why there's a limitation regarding the VBA portion of it.

Would there be a method of coding to force the clipboard contents into a specified string value (as a middle man)? From there, it would then paste the contents of that string value. Just throwing ideas at this point, not particularly sure of the syntax surrounding that (or whether it would function in use).