Macro Help - Copy from Clipboard to start my Macro

[kimon90]

Hi Guys,


I need your help in a macro I am trying to build. I have a procedure where I start by coping to clipboard a row from another excel sheet, with an intention of pasting on my current sheet and edit further.

To automate my procedure, I am running the below macro. When I am running the code, I am getting a 'run-time error '1004'"


PS:

My current code is:

Please Login or Register  to view this content.

Moderator's note: Please take the time to review our rules. There aren't many, and they are all important. Rule #2 requires code tags. I have added them for you this time because you are a new member. --6StringJazzer

I suspect the error occurs as I am not instructing it to copy the clipboard content.

Can you fix my code, for it starts with coping from clipboard (and the rest remain as it is?)

Thanks in advance,

Kimon

[6StringJazzer]

Which sheet is "another sheet" and which sheet is your "current sheet"? Please relate your description to the code.

This code is pasting into sheet DATA1 but you never copy anything. Then it sets

Please Login or Register  to view this content.

which clears the clipboard. Then it tries to paste into SCANER with nothing on the clipboard.

This is not going to be hard to fix but can you describe in detail exactly what you want it to do?

Also, this is macro recorder code, which is usually bloated. If you want to copy from one place and paste the values into another, we can do that with one line of code.

[kimon90]

Hi 6StringJazzer,

Thanks for taking time to reply. "Another sheet" is a source sheet where I start off by copying a row (before I record the macro), then I move to my "current sheet" (where I start recording the macro), which is the sheet I am working on and want to apply my code.

The code is indeed from a recorder, as I do not have coding skills myself.

I start recording the macro in the target sheet (having already copied from the source sheet). Withing the code first action I can do is paste, and this is where my problem is (no copy in code).

I start with having content in my clipboard and the first action of my code should be copying from there, but I am missing this part and I do not have the knowledge to insert it.

So, in summary, what I am trying to do with my code is:

1. Fetch the clipboard content (a row from a different excel sheet)
2. "Paste Special -> Values" at tab "DATA1", row 2.
3. Copy the row 3 from tab "DATA1"
4. "Paste Special -> Values" at tab "SCANER", row 1.

Best Regards,
Kimon

[6StringJazzer]

Do you run the macro after you have already manually copied "a row from a different excel sheet"? Assuming yes, then try this:

Please Login or Register  to view this content.

[kimon90]

Hi 6StringJazzer,

The code worked, thanks. I copy my row and then run the macro and it's great. There's only one problem. If I copy my row, then click anywhere, then run the macro, it doesn't work. I am trying to say that there should be absolutely no actions between copying and running the macro.

Can we fix that ? Should a line be added between the first and second line to ignore any Inbetween actions and go see the clipboard regardless of when the copy was made ?

Thanks in advance,
Kimon

[6StringJazzer]

That's not what happens when I try it. If I copy the row, then click somewhere else, the macro still works. If you copy, then click somewhere else, the dotted-line border around the copied area should still be there, indicating that it's still on the clipboard. If you are doing something to clear the dotted line then maybe you are not just clicking.

Because I cannot reproduce your problem I may need to try it with your file. See yellow banner at the top of the page.