+ Reply to Thread
Results 1 to 5 of 5

Problem with aligning shapes. Specific value out of range error

  1. #1
    Forum Contributor
    Join Date
    01-02-2007
    Location
    Australia NSW
    MS-Off Ver
    2013
    Posts
    494

    Problem with aligning shapes. Specific value out of range error

    Please Login or Register  to view this content.
    The code was working error free for a while, but now error's for some reason.

  2. #2
    Forum Expert romperstomper's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    365, varying versions/builds
    Posts
    21,256

    Re: Problem with aligning shapes. Specific value out of range error

    Which line, which error?
    Remember what the dormouse said
    Feed your head

  3. #3
    Forum Contributor
    Join Date
    01-02-2007
    Location
    Australia NSW
    MS-Off Ver
    2013
    Posts
    494

    Re: Problem with aligning shapes. Specific value out of range error

    Quote Originally Posted by romperstomper View Post
    Which line, which error?
    Error location:
    Please Login or Register  to view this content.
    Error : Value out of Range.....

    After a google it might be the syntax below(removed stop between Shapes and Range:
    Please Login or Register  to view this content.
    Will try that in the morning when back at work.
    Last edited by coreytroy; 08-29-2013 at 04:50 AM. Reason: Additional info added.

  4. #4
    Forum Expert romperstomper's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    365, varying versions/builds
    Posts
    21,256

    Re: Problem with aligning shapes. Specific value out of range error

    No - the original syntax was correct. I suspect one of your shape names is incorrect - probably the
    Please Login or Register  to view this content.
    one.

  5. #5
    Forum Contributor
    Join Date
    01-02-2007
    Location
    Australia NSW
    MS-Off Ver
    2013
    Posts
    494

    Re: Problem with aligning shapes. Specific value out of range error

    Solved.
    For some reason i had to flip the name of each shape so that the numerical value followed the text, and it works as expected. Go figure !!!
    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 14
    Last Post: 08-01-2013, 06:34 AM
  2. [SOLVED] Right-Aligning cells to a specific column
    By Chubster in forum Excel General
    Replies: 10
    Last Post: 11-10-2012, 03:16 PM
  3. [SOLVED] Group Specific Shapes Excel VBA
    By Ganesh7299 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-13-2012, 02:26 AM
  4. Deleting Specific Shapes
    By FrankStallone in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-15-2006, 01:43 AM
  5. [SOLVED] Aligning decimal numers to the centre of the cell and aligning dec
    By Ramesh Babu in forum Excel General
    Replies: 1
    Last Post: 07-01-2006, 05:40 PM

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