+ Reply to Thread
Results 1 to 3 of 3

Identify column of left and right edge of shape

  1. 07-25-2015, 08:42 AM #1
    YasserKhalil
    YasserKhalil is offline
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,892

    Identify column of left and right edge of shape

    Hello everyone
    I have drawn shape("Rectangle 1") on column G thu J
    I have this code that enables me to identify the column to the left of the shape
    Please Login or Register  to view this content.
    I can get 7 for column G

    How can I know the right column of the shape?
    I expect 10 for column J
    < ----- Please click the little star * next to add reputation if my post helps you
    Visit Forum : From Here
    Reply With QuoteRegister To Reply
  2. 07-25-2015, 08:48 AM #2
    ARowbot
    ARowbot is offline
    Valued Forum Contributor
    Join Date
    11-12-2014
    Location
    Nottingham
    MS-Off Ver
    2013
    Posts
    383

    Re: Identify column of left and right edge of shape

    Using the same but instead of top left use bottom right.
    !If all your troubles are solved, then so is the thread. Show this by marking it so using thread tools at the top of the page.
    If I helped do this, then please show your appreciation by awarding rep points.
    <------ Button for that is over there
    Reply With QuoteRegister To Reply
  3. 07-25-2015, 09:26 AM #3
    YasserKhalil
    YasserKhalil is offline
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,892

    Re: Identify column of left and right edge of shape

    Thanks a lot for this simple and perfect solution
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. how to find the forward edge and aft edge for given coordinates
    By naderassaleh in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 03-08-2014, 02:16 PM
  2. OFFSET function - column reference over the edge of the worksheet
    By ronaldev in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-04-2013, 10:09 PM
  3. [SOLVED] Cannot identify shape names in Excel 2007
    By Alley oop in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-14-2012, 10:26 AM
  4. Identify button (shape) row to insert row and delete row
    By wotadude in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 03-22-2012, 12:41 PM
  5. Find Top and Left values for Shape in Chart
    By merkleguy in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 02-04-2012, 08:06 AM
  6. Excel 2007 : How to return to column A after edge of data?
    By Lewis Koh in forum Excel General
    Replies: 2
    Last Post: 02-01-2011, 09:45 AM
  7. contents overflowing column edge
    By monkfunk in forum Excel General
    Replies: 1
    Last Post: 02-17-2009, 04:57 PM
  8. set left rigth margins for header i need it wider to the edge of t
    By Valentin in forum Excel General
    Replies: 0
    Last Post: 09-14-2005, 06:05 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1