+ Reply to Thread
Results 1 to 3 of 3

.TopLeftCell Property

  1. 11-30-2016, 07:26 AM #1
    AdiK
    AdiK is offline
    Registered User
    Join Date
    10-25-2016
    Location
    mumbai
    MS-Off Ver
    2010
    Posts
    47

    .TopLeftCell Property

    Hello Guys,

    Can somebody explain what does .TopLeftCell property does in layman terms?

    Thanks in Advance
    Reply With QuoteRegister To Reply
  2. 11-30-2016, 07:48 AM #2
    Tsjallie
    Tsjallie is offline
    Forum Expert Tsjallie's Avatar
    Join Date
    09-15-2012
    Location
    NL
    MS-Off Ver
    2010, 2013, 2016
    Posts
    2,077

    Re: .TopLeftCell Property

    If you would have some shape in your sheet, then TopLeftCell is the cell which is under the topleft corner of the shape.
    TopLeftCell has the same properties as a range.
    So suppose you have a shape like in the attached screenshot, then 
    Please Login or Register  to view this content.
    will return the address of that cell ($C$2)
    Attached Images Attached Images
    Cheers!
    Tsjallie



    --------
    If your problem is solved, pls mark the thread SOLVED (see Thread Tools in the menu above). Thank you!

    If you think design is an expensive waste of time, try doing without ...
    Reply With QuoteRegister To Reply
  3. 11-30-2016, 08:18 AM #3
    AdiK
    AdiK is offline
    Registered User
    Join Date
    10-25-2016
    Location
    mumbai
    MS-Off Ver
    2010
    Posts
    47

    Re: .TopLeftCell Property

    Thank You
    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. [SOLVED] Shapes, TopLeftCell. Row incorrect
    By malcmail in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-28-2014, 08:18 AM
  2. Creating buttons using TopLeftCell
    By Ben F. in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-23-2013, 09:57 AM
  3. [SOLVED] Excel run-time error '381': Could not set the List property. Invalid property array index
    By eemiller1997 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 12-20-2012, 12:48 PM
  4. Understanding Cells property vs. Offset property (implicit vs explicit references)
    By Wedge120 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-26-2010, 10:38 PM
  5. TopLeftCell change to "bottom"LeftCell
    By M John in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-16-2006, 08:55 PM
  6. problem w/ size of combobox & using TopLeftCell
    By Bill_excelforum in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-08-2006, 06:05 PM
  7. [SOLVED] range variable won't assign (chartobject.topleftcell property)
    By Matthew Dodds in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-16-2005, 10:30 AM
  8. [SOLVED] TopLeftCell.Address for buttons from forms toolbar
    By Andy in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-11-2005, 01:20 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