Hi TTomSawyer,

In the absence of your code, perhaps data could be copied as values rather
than formulas.

If this is not a viable option, it would be necessary to evaluate the cell
which determines the last row on the target sheet, to determine if it
contains a formula which resolves to an empty string.

Post the button code and indicate if values may be copied to the target
sheet.


---
Regards,
Norman



"TTomSawyer" wrote
in message ...

Hi,

I have a macro and a button setup to copy and paste a coupld columns
and rows into another worksheet. The pasting material is different
columns (name, date, amount spent, etc) with several rows for the
different information from each individual input. There are 30 rows in
total. The macro highlights all 30 rows then over 4 columns. It
copies the material, goes to the other worksheet with similar headings,
finds the last entered row, and pastes the information into the sheet.


The problem is:
When the macro copies formulas that end up equaling "" (nothing there),
it copies something? but it doesnt appear anywhere when it is pasted.
HOWEVER, when the macro goes to the last entered row, it takes in
account the blanks from the previous paste. How can I get rid of
these, so it pastes directly after the last REAL number, instead of
several "blanks"?

Does this make sense? I can send the sheet in order to show you what
it looks like.


--
TTomSawyer
------------------------------------------------------------------------
TTomSawyer's Profile:
http://www.excelforum.com/member.php...o&userid=20511
View this thread: http://www.excelforum.com/showthread...hreadid=395945