Re: Pasting Blanks using a macro

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 ***, 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
***.


---
Regards,
Norman



"TTomSawyer" <TTomSawyer.1ttt2h_1124143531.57@xxxxxxxxxxxxxxxxxxxxx> wrote
in message news:TTomSawyer.1ttt2h_1124143531.57@xxxxxxxxxxxxxxxxxxxxxxxx
>
> Hi,
>
> I have a macro and a button setup to copy and paste a coupld columns
> and rows into another work***. 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 work*** with similar headings,
> finds the last entered row, and pastes the information into the ***.
>
>
> 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 *** in order to show you what
> it looks like.
>
>
> --
> TTomSawyer
> ------------------------------------------------------------------------
> TTomSawyer's Profile:
> http://www.excelforum.com/member.php?action=getinfo&userid=20511
> View this thread: http://www.excelforum.com/showthread.php?threadid=395945
>


.

Loading