I have a macro that copies and pastes information from spreadsheet to the other.
I also have the following function
Application.DisplayAlerts = False
It seems to input this functions in to a cell on the spreadsheet itself
is this a known bug?
I am attaching the spreadsheet with the bug as well as the code
How can this be solved?
Please Login or Register to view this content.
Your attachment downloads as a Word document "Clear All Budgets" which contains code in text format.
Could you attach an Excel workbook?
_
...How to Cross-post politely...
..Wrap code by selecting the code and clicking the # or read this. Thank you.
not for me it doesn't! i get find_photo.xlsm
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
Is there any solution to this issue?
What is the code meant to do and what is the problem with it?
If posting code please use code tags, see here.
Try to run the macro in the spreadsheet attached.
Sub InsetImage()
You will be able to see that the macro inputs into the new spreadsheet the following Application.DisplayAlerts
well apart from the fact its extemely slow, it is NOT adding Application.DisplayAlerts = False
from the code
it is adding the last thing you copied to the clipboard tho
copy something else any thing then run it
eg this text "oh what is this doing here,hmmmm"
Why do you have this?That will copy whatever is on the clipboard to the new sheet in the new workbook.Please Login or Register to view this content.
In my case it copied Option Explicit to A5, where A5 was the last cell selected in the sheet that was copied.
What can I do in order to solve the issue?
I tried to empty the clipboard info however this is not working.
What is your recommendation in order to speed up the code?
Thank you for your help
To resolve the issue delete this line as it doesn't really do anything, well not anything you want as far as I can see.
As for speeding things up, I'm not sure you can make any changes to the code to do that as the reason the code is so slow is it's downloading the images from the internet.Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks