+ Reply to Thread
Results 1 to 2 of 2

adjust shape to center?

  1. 08-16-2009, 11:10 AM #1
    Armitage2k
    Armitage2k is offline
    Forum Contributor
    Join Date
    03-24-2009
    Location
    Vietnam
    MS-Off Ver
    Excel 2010
    Posts
    382

    adjust shape to center?

    Hi!

    I have many small shapes in my range from L3:L100. now, I would like to have all of them adjusted to the center of the cell, both vertically and horizontally. Unfortunately I cannot find a way to do so which is recognized by the macro recorder...

    Any ideas?
    Thanks,
    A2k
    Reply With QuoteRegister To Reply
  2. 08-16-2009, 12:03 PM #2
    shg
    shg is offline
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: adjust shape to center?

    Shapes and ranges both have Left, Top, Width, and Height properties -- so, for example, the x center is .left + .width/2
    Entia non sunt multiplicanda sine necessitate
    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)

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