Manipulating Excel: How to change cell Color
Manipulating Excel: How to change cell Color
(OP)
How can I change the background color of one cell within a EXTRA! Basic Macro?
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS Contact USThanks. We have received your request and will respond promptly. Come Join Us!Are you a
Computer / IT professional? Join Tek-Tips Forums!
*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail. Posting Guidelines |
Manipulating Excel: How to change cell Color
|
Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.
Here's Why Members Love Tek-Tips Forums:
Register now while it's still free!
Already a member? Close this window and log in.
RE: Manipulating Excel: How to change cell Color
Hi,
Post whatever code you already have that instantiates the Excel application object and references an Excel workbook/worksheet.
Skip,
Just traded in my old subtlety...
for a NUANCE!
RE: Manipulating Excel: How to change cell Color
excelReport.Workbooks.Add
Set objSheet1 = excelReport.ActiveWorkbook.WorkSheets(1)
RE: Manipulating Excel: How to change cell Color
CODE
Set xlWB = excelReport.Workbooks.Add
Set objSheet1 = xlWB.WorkSheets(1)
objSheet1.cells(1,1).interior.color = vbred
Skip,
Just traded in my old subtlety...
for a NUANCE!