LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
iwl iwl is offline
external usenet poster
 
Posts: 6
Default Range("A1").Interior.ColorIndex=xyz does not work

Hello Group,

I try to set Cell Background-Color with
Range("A1").Interior.ColorIndex=xyz
but does not work while I can read out the value
and it is different when I set it with Cell Format
in Excel manualy if I set it from vba it isn't so
red back again
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
"Error 1004 Unable to set the ColorIndex property of the Interior. Bob Barnes Excel Programming 3 April 30th 07 06:42 PM
"COUNTIF" using ".ColorIndex" and "AND" styne666 Excel Programming 2 February 6th 07 04:35 PM
use variable in Workbooks("book1").Worksheets("sheet1").Range("a1" Luc[_3_] Excel Programming 2 September 28th 05 08:37 PM
Cell.interior.colorindex - does not work in Excel 97 Ian[_13_] Excel Programming 10 April 5th 05 07:28 PM
Why doesn't "Workbook.Range("myrange").value" work? Brad Patterson Excel Programming 0 July 9th 03 01:24 AM


All times are GMT +1. The time now is 11:34 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"