Copy - Paste
Edgar Thoemmes wrote:
Another question relating to the import of some data from
another book.
After I have copied the data from the sheet I get the
messgage 'There is a large amount of data on the
Clipboard - Do you want to make this available to other
programs?
Is is possible for excel not to display this message.
I have tried application.screenupdating = false but this
is not working
What you need is Application.DisplayAlerts = False, then set it back to
true.
I'm not sure waht will be the behaviour if the messagebox is skipped so
you'll have to try it out.
Regards,
--
Beto
Reply: Erase between the dot (inclusive) and the @.
Responder: Borra la frase obvia y el punto previo.
|