![]() If there is a way to simplify the deletion of 2 specific images from 2 specific cells, I am okay with that.this was just the closest I could get. I have tried changing to something like this but it does not seem to solve the issue 100% of the time: If Worksheets("Layout1").Shapes.Count > 0 ThenĪny help is greatly appreciated. If = imgThumbDeleteRange.Address Then shThumb.Delete You can use Excel to enter all sorts of data and perform financial, mathematical or. Set imgThumbDeleteRange = Worksheets("_SETUP").Range("元3")įor Each shThumb In Worksheets("_SETUP").Shapes Hundreds of millions of people around the world use Microsoft Excel. ' then delete the thumbnail on the _SETUP sheet If = imgBigDeleteRange.Address Then shBig.Delete Set imgBigDeleteRange = Worksheets("Layout1").Range("A2")įor Each shBig In Worksheets("Layout1").Shapes ' first delete the primary image on the Layout1 sheet My code is here: Private Sub killImages() I have NO idea how to go about verifying that the Shape (in this case an image) exists prior to the error being thrown. I am pretty sure I need to add logic to check if there is a Shape on the Worksheet before comparing the TopLeftCell.Address (since if it is empty, there is no such address or cell). Object doesn't support this property or method ![]() Errors are on the very last "if" 2 lines from the end:Īpplication-defined or object-defined error '1004" It all seems to be working as long as there really is an image.but if the image has already been deleted then it freaks out and throws an error. One sheet is called "_SETUP" and the other sheet is "Layout1". Con Excel podrás llevar la contabilidad de tus proyectos, así como. Microsoft Excel integrates with 6000 other apps on Zapier - its the easiest way to. ![]() Use modern formulas to perform calculations. Easily create new spreadsheets or start with templates. Es un software de hoja de cálculo que permite a los usuarios realizar cálculos, analizar datos y crear gráficos y tablas para presentar información de manera clara y concisa. Save time as Excel learns your patterns and organizes your data. Microsoft Excel es una de las herramientas más populares y útiles en el mundo de los negocios, la educación y la investigación. I have an image on two worksheets within the same workbook. Microsoft Excel es el programa de hojas de cálculo más utilizado del mundo, tanto en entornos laborales como domésticos. Instantly connect Microsoft Excel with the apps you use everyday. With 1 TB of OneDrive cloud storage, you can back up, share and co-author workbooks from any device.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |