+ Reply to Thread
Results 1 to 4 of 4

Picture Rotation (180° Inversion) Problem

  1. #1
    Registered User
    Join Date
    11-26-2012
    Location
    Sri Lanka
    MS-Off Ver
    Excel 2013
    Posts
    35

    Picture Rotation (180° Inversion) Problem

    Dear All:

    I am making this Tarot Card Program and need some help. The attached .jpeg explains my problem.

    When a `Tarot Deck` is shuffled and dealt (called a Spread) some cards land upside down (Inverted). It is meant to be so.

    When cycling through the Picture Cards stored in a worksheet I keep changing the A1 cell randomly between 0 & 1. If A1 = 1 then the card has to be flipped upside down. I have shown only 5 cards here. The 2nd & the 4th are `flipped`, which I did manually.

    I believe this has to do with a Keyword / Method which is probably obsolete. I am using Excel 2013.

    Any help is much appreciated. Thank you in advance.
    Attached Images Attached Images
    Thanks a lot...

    - pd -

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,436

    Re: Picture Rotation (180° Inversion) Problem

    The IncrementRotation is being applied to the selection, nothing in your code suggests the selection is a tarot card.
    Try this code instead

    Please Login or Register  to view this content.
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    11-26-2012
    Location
    Sri Lanka
    MS-Off Ver
    Excel 2013
    Posts
    35

    Re: Picture Rotation (180° Inversion) Problem

    Thank you very much Andy... will try that and revert...

    Meanwhile, I might need your further assistance in `deselecting` all the pictures on this worksheet after `this pass` in preparation for the next hand (`Spread) to be dealt...

    I think I have an idea... but let me cross that bridge when I come to it...

    Cheers...

  4. #4
    Registered User
    Join Date
    11-26-2012
    Location
    Sri Lanka
    MS-Off Ver
    Excel 2013
    Posts
    35

    Re: Picture Rotation (180° Inversion) Problem

    Dear Andy: You are Brilliant!!! Here is the result. No need of a ‘Reset’ of cards as they randomly set themselves every time the Procedure runs… Thank you very much. I will mark this problem as ‘Solved’ and add a Star to your Profile. May God Bless you…

    Attachment 726326
    Attachment 726327
    Attachment 726328
    Attachment 726329
    Attachment 726330
    Attached Files Attached Files

+ 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. Picture Rotation Macro based off of Reference Values
    By BenJamDu in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-22-2015, 10:51 AM
  2. Picture Rotation Macro based off of Reference Values (Novice)
    By BenJamDu in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-21-2015, 01:57 PM
  3. Problem: Another Dart Team Rotation
    By olsonoski in forum Excel General
    Replies: 2
    Last Post: 10-12-2014, 05:36 PM
  4. Picture rotation invalidates .Top and .Left
    By MadeOfAir in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-10-2013, 08:23 AM
  5. data inversion!
    By via135 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-07-2006, 05:12 AM
  6. Inversion of numbers
    By Gary B. Berns in forum Excel General
    Replies: 3
    Last Post: 06-16-2005, 04:05 PM
  7. Autoshape Fill Rotation Problem
    By David Godinger in forum Excel General
    Replies: 1
    Last Post: 05-09-2005, 06:06 PM

Tags for this Thread

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