Hi.
When the code tries pasting something i get this error message: "paste special method of range class failed".
Here's my code, see the red font....
Please Login or Register to view this content.
Hi.
When the code tries pasting something i get this error message: "paste special method of range class failed".
Here's my code, see the red font....
Please Login or Register to view this content.
Last edited by kosherboy; 06-12-2014 at 09:58 AM.
Never mind... i forgot to copy a value
Is something copied?
Hope this helps
Sometimes its best to start at the beginning and learn VBA & Excel.
Please dont ask me to do your work for you, I learnt from Reading books, Recording, F1 and Google and like having all of this knowledge in my head for the next time i wish to do it, or wish to tweak it.
Available for remote consultancy work PM me
That was the part that i forgot to put in the code.
This is how it should have looked:
Please Login or Register to view this content.
Range("F" & rCell).value =Range("K" & rCell).value
would be better than your code then, no need for cutting and pasting.
True, but i am actually just posting an example of the real code that i had issues with (and i still have issues with). That code is copying a cell from a different workbook and pasting it into the "rCell".
Can i post it for you to look at?
See red font with the issue.
Enjoy
Please Login or Register to view this content.
If the workbooks are open you can do the same
open your work book into a variable
ActiveSheet.Copy
set wbNew = activeworkbook
then range("S" & rcell).value = wbNew.range("H16")
i think , i am not in excel at the minute
I hear but that workbook gets closed by the code. And it's imperative that the workbook gets closed.
Please Login or Register to view this content.
You're closing the activewindow not the activeworkbook.
What should the difference be then?
What can i do to fix the issue?
Activeworkbook.close savechanges:=true/false
It's still not working
I don't mind waiting...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks