+ Reply to Thread
Results 1 to 5 of 5

Determine if a shape occupies a range of pixels

  1. #1
    Registered User
    Join Date
    03-22-2011
    Location
    Orlando, Fl
    MS-Off Ver
    Excel 2007
    Posts
    15

    Determine if a shape occupies a range of pixels

    I want to determine if a shape is occupying a range of pixels. If it is, I do not want to place my new shape on top of any part of it. Instead, maybe place it on the next available row and column of pixels where the existing shape is not occupying.

    Is there an easy way to determines if a shape exists in a range of pixels without having to keep up with a list of pixel ranges where a shape has already been added.

    Thanks

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,436

    Re: Determine if a shape occupies a range of pixels

    you can use a shapes left/top/width/height properties to determine whether a shape will overlap other shapes.
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    03-22-2011
    Location
    Orlando, Fl
    MS-Off Ver
    Excel 2007
    Posts
    15

    Re: Determine if a shape occupies a range of pixels

    Can you explain a bit Andy? From what I gather what you are saying, for the pre-existing shape I would have to already know what pixel ranges it occupies, then I can check the properties of my new shape to see if any overlap the pixels of the pre-existing shape.

    This would be akin to my answer of having to keep up a list of pixels already occupied by shapes. Is there a way to know if a range of pixels contains a shape in them. Maybe some sort of IF statement where I say IF pixel-A contains shape then ...

  4. #4
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,436

    Re: Determine if a shape occupies a range of pixels

    Yes but you do not have to keep the information it already exists in the Shapes collection.

    Please Login or Register  to view this content.

  5. #5
    Registered User
    Join Date
    03-22-2011
    Location
    Orlando, Fl
    MS-Off Ver
    Excel 2007
    Posts
    15

    Re: Determine if a shape occupies a range of pixels

    Thanks! I think that gets what I was looking for!

+ 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