+ Reply to Thread
Results 1 to 2 of 2

Rectangles, 1000's of them in spreadsheet.

  1. #1
    Registered User
    Join Date
    05-10-2004
    Posts
    28

    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

    Rgds
    Okanem

  2. #2
    Forum Moderator dominicb's Avatar
    Join Date
    01-25-2005
    Location
    Lancashire, England
    MS-Off Ver
    MS Office 2000, 2003, 2007 & 2016 365
    Posts
    4,867

    Smile

    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).

    HTH

    DominicB
    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)

Bookmarks

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