Leave destination cells blank when origin cells contain value 0

Hey everyone,

Im a noob when it comes to programming in excel, but i need a little help with completing the following macro.

Please Login or Register  to view this content.

As you can see it's very simple and it works. However some cells in the original range have values of 0. Instead of pasting the value 0 in the destination cells, i would like the macro to leave those blank. I tried using some 'IF' functions but could not get it to work.

Any help would be greatly appreciated.
Thanx.

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here

Something Like this should work:

Please Login or Register  to view this content.

oops you want it pasting underneath don't you see above as i have altered it

you just need to select a single cell so something like:

Please Login or Register  to view this content.

put that at the end and it will be fine

Feel free to add to my rep by clcick on the scales in the top right