I am trying to use the above code to copy data from one sheet and paste special/skip blanks on a second sheet. I want all the formatting and formulas, but I want to skip the blank cells so it does not replace the data I have already entered. For some reason, I keep getting an error and the debugger highlights the Activesheet.Pastespecial part of the code. What am I doing wrong here?
Please Login or Register to view this content.
Last edited by pingwin77; 04-14-2011 at 03:58 PM.
try activecell rather than activesheet
also check the help on PasteSpecial.Please Login or Register to view this content.
So I got the code to skip blanks, the issue I now have is that It only pastes the cells with stuff in them. I have blank cells with formatting (Color, borders) that I need to copy as well. Should I add a separate line of code that pastes formats or can this be done with the same line of code that skips blanks?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks