I have a copy/paste macro and my copying range has some blank cells in it and some cells that are 0. When I paste the data it fills in the blank cells with 0's.
Is there some code I can add so if the value is a zero it shows a zero and if the cell is blank it shows a blank?
To know how to approach this it would be useful to see your original copying code
Please help by:
Marking threads as closed once your issue is resolved. How? The Thread Tools at the top
Any reputation (*) points appreciated. Not just by me, but by all those helping, so if you found someone's input useful, please take a second to click the * at the bottom left to let them know
There are 10 kinds of people in this world... those who understand binary, and those who don't.
This is my original code. Thanks
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks