runtime error 1004 pastespecial method of range class failed

I am encountering this error when I try to run code I have written on my own machine. I am working with all unprotected sheets, and I am running Excel 2007. All of the sheet exist.

Here is my code:

Please Login or Register  to view this content.

Thanks~ Jh

Quite apart from anything else, you need to first tell Excel what you want to paste. If you were doing it manually, you'd do Copy and then Paste wouldn't you.

Right Stephen. I am not having any problem with the copying part.

And I am able to copy a value from a field and put it into a variable, and then spit it out into a cell using

Please Login or Register  to view this content.

However, I am unable to get the PasteSpecial or Paste commands to work.

I hope this explains more.

Thanks! Jh

bitterenemy,

i tried your suggestion for the range, and now the error i recieve is pretty much the same, but more generic: '1004' application or object-defined error.

thanks~ Jh

But you're not copying anything!

Stephen,

I realize that I have not copied anything in the code that I have posted before... I assure you that the copy function is working just fine. Here is my code that copies, as I have said before, the problem I am having is with pasting the row that I've copied.

Please Login or Register  to view this content.

I appreciate that but it helps if you post all relevant code as is. Now I don't know where this code fits with your previous code. Is the former immediately before the latter? The code works for me but I guess there are other things you are doing.

Please Login or Register  to view this content.

Notes:
I have kept all the methods I've tried for the paste special and just commmented them and numbered them, and noted the errors I've been getting.
The only one that works is #3, however, this does not paste the whole row, it pastes the value in the second column only.

Thanks~ Jh

You appear to refer to strcurrCellAddr before it's defined in your code? It might be easier if you can simply explain what you're trying to achieve and perhaps attach a small sample workbook.

So, I've been looking around and I think I've figured out why I'm getting this error.... because the buffer is immediately erased when I select the second sheet- and there is nothing on the clipboard/buffer to paste!

thought you all might like an update.

many thanks! Jh