I need to create a new worksheet in my workbook which is largely a copy of
an existing one. So, I made a copy of the worksheet. Then, in cell A1, I
set it equal to the old worksheet's cell A1. That worked fine, but since
there are lots of empty spaces in between important rows and columns in the
old worksheet, I'd like the new one to have empty spaces there too. When I
simply copy the equation =oldsheetA1 from cell A1 of the new sheet, across
and down, I get a bunch of zeroes where the old sheet is blank, and I want
blanks in the new sheet too. Unfortunately, there are many blanks and they
appear almost randomly so it would be very time consuming to simply go to
each new empty cell and delete it. Also, sometimes the zeroes are a result
of a computation, not merely an indication that the old worksheet's cell was
a blank.

I was thinking I could use some sort of isempty function but I'm not sure
there is such a thing, anyway I'd rather not have RAM wasted on such a
thing. I'd be happier to do the copying from cell A1 to the rest of the
worksheet with a macro. The macro should simply set newsheet equal to
oldsheet whenever old sheet has something in it. If not, it should leave it
blank. If it helps, the worksheet has only 250 rows but almost the entire
maximum range of columns.

Thanks
Dean