Results 1 to 5 of 5

Thread: Get the shape's RGB value

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #5
    Hi Kenneth,
    Yes, there will be sheet named summary.
    May I know for the 'Selection.Name', does it mean I have to define the shape's name in the code in order to run?
    Coz I get error of 1004: Application-defined or object-defined error.

    I try to modify the code into
    colr = Selection.ShapeRange.Fill.ForeColor

    It works~
    Though I don't understand why....
    Last edited by ooitzechyi; 10-05-2016 at 05:44 PM.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •