clipboard full

[jnewl]

i am creating a macro whereby i take the contents of several worksheets and
compile a final workbook. i have a template of the final workbook whereby i
do a lot of cell calculations rather than clutter the excel macro.

so when i populate the template, i get my calculations performed

when i was building the macro, i got screen messages that indicated i had
lots of info on the clipboard and did i want to delete or save. i deleted.
when i run the macro, i get these screen messages. how do i get rid of the
messages

[Crowbar via OfficeKB.com]

at the start of the code try:

application.displayalerts = false

--
Message posted via http://www.officekb.com

[jnewl]

thanks

"jnewl" wrote:

> i am creating a macro whereby i take the contents of several worksheets and
> compile a final workbook. i have a template of the final workbook whereby i
> do a lot of cell calculations rather than clutter the excel macro.
>
> so when i populate the template, i get my calculations performed
>
> when i was building the macro, i got screen messages that indicated i had
> lots of info on the clipboard and did i want to delete or save. i deleted.
> when i run the macro, i get these screen messages. how do i get rid of the
> messages