+ Reply to Thread
Results 1 to 5 of 5

Run time error 438 for shape fill

  1. #1
    Registered User
    Join Date
    10-05-2011
    Location
    South Wales
    MS-Off Ver
    Excel 2007
    Posts
    2

    Run time error 438 for shape fill

    I have a long code that worked perfectly before. When I added some code regarding shape fill colour I had a runtime error 438. I removed this code and tested it on a seperate tab to see what the problem is but I still get the error. I have written code before to fill a shape a certain colour and never had this problem. I am really confused. Here is the simple code
    Please Login or Register  to view this content.
    If I enter Green into L14 the line error occurs at the line in bold. What am I doing wrong?
    Last edited by Lotty; 10-05-2011 at 07:50 AM. Reason: code tags

  2. #2
    Forum Expert Colin Legg's Avatar
    Join Date
    03-30-2008
    Location
    UK
    MS-Off Ver
    365
    Posts
    1,255

    Re: Run time error 438 for shape fill

    Welcome to the forum.

    Please would you edit your post and wrap code tags around your code? See how in my signature.

    While you're editing your post, have a careful look at the code and see if you can spot any typos in there.
    Hope that helps,

    Colin

    RAD Excel Blog

  3. #3
    Forum Guru romperstomper's Avatar
    Join Date
    11-04-2008
    Location
    A1
    MS-Off Ver
    Most
    Posts
    12,302

    Re: Run time error 438 for shape fill

    Especially the spelling of RGB...
    Remember what the dormouse said
    Feed your head

  4. #4
    Registered User
    Join Date
    10-05-2011
    Location
    South Wales
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: Run time error 438 for shape fill

    Such a silly error. I have been looking at it for nearly 4 hours and something that obvious just passed my eyes. School boy error.

  5. #5
    Forum Guru romperstomper's Avatar
    Join Date
    11-04-2008
    Location
    A1
    MS-Off Ver
    Most
    Posts
    12,302

    Re: Run time error 438 for shape fill

    If you are satisfied with the solution(s) provided, please mark your thread as Solved.

    How to mark a thread Solved
    Go to the first post
    Click edit
    Click Go Advanced
    Just below the word Title you will see a dropdown with the word No prefix.
    Change to Solved
    Click Save

    Also note Colin's comments about code tags. I added them for you as it was your first post, but you must learn to use them in future, please.

+ Reply to 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1