+ Reply to Thread
Results 1 to 2 of 2

Rectangles, 1000's of them in spreadsheet.

  1. #1
    Registered User
    Join Date

    Rectangles, 1000's of them in spreadsheet.

    For some reason one of my excel spreadsheets was sitting at 5Mb, it contained 4 tabs with a little data in each and a logo on top. I deleted the logo off each tab but still 5Mb. I then stumbled across a small rectangle on one of the tabs so I deleted it, then I found another one. Its description at the top left was rectangle 4133, so I typed in Rectangle 2000 and one appeared. I dont know how they got there but there are a lot of them.

    Can anyone devise a macro to delete all rectangles?

    Hope you can help


  2. #2
    Forum Moderator dominicb's Avatar
    Join Date
    Lancashire, England
    MS-Off Ver
    MS Office 2000, 2003, 2007 & 2016 365


    Good morning okanem

    Run the macro below. This will select them all, so you can see where they all are. Then just press "Delete".

    Please Login or Register  to view this content.
    If you are comfortable using the VBE you could run just the single line from the immediate window (press Ctrl + g).


    Please familiarise yourself with the rules before posting. You can find them here.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1