Solved

Select specific RGB cell color

Posted on 2013-12-15
1
333 Views
Last Modified: 2013-12-15
Folks,
I would like to set the interior color of a cell to a defined color. I've tried the code below and it is not working:
Range("N22").Select
With Selection
.Interior.ColorIndex = RGB(83, 141, 213)
End With
Worksheets("CalAverLargestNumbers").Range("N22").Interior.ColorIndex = RGB(83, 141, 213)

Open in new window

0
Comment
Question by:Frank Freese
1 Comment
 

Accepted Solution

by:
Frank Freese earned 0 total points
ID: 39720396
figured it out:
Range("N22").Interior.color = RGB(83, 141, 213)
0

Featured Post

Active Directory Webinar

We all know we need to protect and secure our privileges, but where to start? Join Experts Exchange and ManageEngine on Tuesday, April 11, 2017 10:00 AM PDT to learn how to track and secure privileged users in Active Directory.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Introduction This Article is a follow-up to my Mappit! Addin Article (http://www.experts-exchange.com/A_2613.html), it was inspired by an email posting I made to EUSPRIG (http://www.eusprig.org/index.htm), I will briefly cover: 1) An overvie…
Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.

830 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question