Thread: Cell.interior.colorindex - does not work in Excel 97
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Ron de Bruin Ron de Bruin is offline
external usenet poster
  
Posts: 11,123
Default Cell.interior.colorindex - does not work in Excel 97
Is it working if you run the macro with Alt-F8 instead of
using the button

--
Regards Ron de Bruin
http://www.rondebruin.nl



"Ian" wrote in message ...
On Tue, 5 Apr 2005 17:23:08 +0200, "Ron de Bruin"
wrote:

Hi Ian

0 not exist
White is colorindex -4142

Try this in 97
ActiveCell.Interior.ColorIndex = -4142


Sorry, Ron,

Still does not work.

Cheers,

Ian,


Reply With QuoteReply With Quote