Terima kasih Pak Hendrik
Salam Lukman On Wed, Jul 15, 2015 at 1:45 PM, hendrik karnadi [email protected] [belajar-excel] <[email protected]> wrote: > > > Koreksi dikit > Coba ganti vbYellow atau 25 dengan xlNone. > > Tanda "*:*" (titik dua) *dibuang*. > > Jadi perintahnya: > Range("A1").Interior.Color = xlNone > Range("A1").Interior.ColorIndex = xlNone > > > Salam, > HK > > > ----- Forwarded Message ----- > *From:* "Hendrik Karnadi [email protected] [belajar-excel]" < > [email protected]> > *To:* [email protected] > *Sent:* Wednesday, 15 July 2015, 12:47 > *Subject:* Re: [belajar-excel] Warn > > > > > Hai Lukman, > Coba ganti 25 dengan xlNone. > > Salam, > HK > > > Sent from Samsung Mobile > > > -------- Original message -------- > From: "lkm jktind [email protected] [belajar-excel]" > Date:15/07/2015 12:33 PM (GMT+07:00) > To: "belajar-excel@yahoogroups com" > Subject: [belajar-excel] Warna > > > Tanya : Range("A1").interior.color = VByellow atau colorindex:=25 > > bila hendak di kembalikan ke semula --- (defaultnya.) > > maka .interior.color = ????? atau colorindex:= ?? > > Salam > > Lukman > > > > >
