Run-time error '1004': Method 'range' of object '_Global' failed
Hi all,
I am getting this issue on my code below. Does anyone know why? It works fine for column Q but not for column V.
I get the error on this line " Range("V8:V" & lastrow).PasteSpecial Paste:=xlPasteFormulas, Operation:=xlPasteSpecialOperationNone, skipblanks:=True, Transpose:=False"
Please Login or Register to view this content.
Step through the code and use a message box to display lastrow when it reaches the column you get an error in.
<---If my answer helped, please click *
I would avoid copy-and-paste all together.
but i need to copy and paste formulas (just formulas to be exact)Originally Posted by joe31623
not exactly sure what you mean by this. Can you explain more in detail please?
Thanks for trying to help!
Ok not sure what happened but i just closed the file and reopen..ran the macro step by step (F8) and it has no issues. Not sure what it was but hopefully i dont get it again.
Rube,
I believe you can do it without copy/paste using a .FillDown and/or .SpecialCells method, but if you're able to get it to work with copy/paste and it doesn't cause you any issues or take too long, just do what works.
If it takes too long, let me know and I'll construct a solution for you.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks