Consulting

Results 1 to 3 of 3

Thread: Find row based on picture

  1. #1

    Find row based on position of picture

    Hi there

    Does anybody know how to get the corresponding row of the bottom of a inserted picture (based on report made from 3rd party software so i have no control over where pictures are placed)?

    Thanks in advance!
    Last edited by faarikaal; 07-30-2010 at 06:29 AM.

  2. #2
    Knowledge Base Approver VBAX Wizard p45cal's Avatar
    Joined
    Oct 2005
    Location
    Surrey UK
    Posts
    5,876
    where xxx is your picture:
    bottomrow=xxx.BottomRightCell.Row
    p45cal
    Everyone: If I've helped and you can't be bothered to acknowledge it, I can't be bothered to look at further posts from you.

  3. #3

    Brilliant

    Works like a charm!!!

Posting Permissions

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