-
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
-
Forum Rules