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 Set imgThumbDeleteRange = Worksheets("_SETUP").Range("元3")įor Each shThumb In Worksheets("_SETUP").Shapes Descargar ahora Microsoft Excel para Mac desde Softonic: Descarga gratis, 100 segura y libre de virus. ' then delete the thumbnail on the _SETUP sheet Microsoft Excel is the world’s most famous and widely used spreadsheet editing application.Originally developed by Microsoft in 1987, this software received numerous expansions of capabilities, making it the go-to source for spreadsheet editing, the use of graphing tools, pivot tables, macro programming, and much more. 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() 3 With Microsoft 365 you get the full, installed Office experience on PCs, Macs, tablets (including iPad® and Android tablet) and phones. I have NO idea how to go about verifying that the Shape (in this case an image) exists prior to the error being thrown. Microsoft 365 plans include premium versions of these applications plus other services that are enabled over the Internet, including online storage with OneDrive and Skype minutes for home use. 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". En este sentido, con los macros de Excel puedes programar bases de datos, formularios, algoritmos, visitas Web y mucho más. ![]() I have an image on two worksheets within the same workbook. Para los expertos en Microsoft Excel existen los macros que se emplean mediante un lenguaje de programación y que son muy prácticos a la hora de automatizar procesos y hojas de trabajo.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |