View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Ken McLennan[_4_] Ken McLennan[_4_] is offline
external usenet poster
 
Posts: 29
Default .interior.color hates me

G'day there Mr McGimpsey,

I just tried to alter a target's interior color property from the
immediate window while the code was paused at a break point. That didn't
work either.

I then tried the same thing with another cell on the same sheet
and it worked OK from the immediate window.

I've just now tried to alter a cell with the address target.offset
(whatever, whatever) and that worked OK. The interior & bold properties
changed like they were supposed to.


I just had another play with it, and I've found that the
fltrCriteria range (all the headings) won't change interior color even
when I use the fill button on the toolbar to make it bright yellos. It
stays the same color (light blue) but when I look at the format box from
the right click menu, the sample on the 'Patterns' tab is bright yellow
and the 'Font' tab shows Bold. Something is amiss, but it's got me
stuffed.


--
See ya,
Ken McLennan
Qld, Australia