I'd do some checking first.

Maybe the cells that you're copying aren't really empty. The values could be
hidden by a custom number format, a font color that matches the fill color, or
conditional formatting.

And if the cells really are empty, I'd look for some sort of event
(worksheet_change) macro that's "fixing" your empty cells to show what you see.

And one more...

Is there a chance that you're pasting using pastelink--so that you end up with a
formula? (0.00 in each cell or "0.00 0.00 0.00" in a single cell???)

Andrew wrote:

Hello,
I'm using VBA code to copy and paste some data from one sheet to
another. On sheet 1, there are a few cells which are blank. When
they get pasted to sheet 2, the corresponding cells have the following
format:

0.00 0.00 0.00

This is one cell, not three. I have tried to clear formatting, but
this is how it is getting pasted. Any ideas on how to fix this
through VBA?

thanks

--

Dave Peterson