n.FormatConditions(Selection.FormatConditions.Count).SetFirstPriority
With Selection.FormatConditions(1).Interior
.PatternColorIndex = xlAutomatic
.ThemeColor = xlThemeColorAccent2
.TintAndShade = 0.599963377788629
End With
Selection.FormatConditions(1).StopIfTrue = True
End Sub
---
ction.FormatConditions.Count).SetFirstPriority
With Selection.FormatConditions(1).Interior
.PatternColorIndex = xlAutomatic
.ThemeColor = xlThemeColorAccent2
.TintAndShade = 0.599963377788629
End With
Selection.FormatConditions(1).StopIfTrue = True
End Sub
To: bela
= "=SUM(R[-" & barisakhir - barisawal + 1 &
"]C:R[-1]C)" To: belajar-excel@yahoogroups.com
From: jkss...@live.com
Date: Thu, 23 Jun 2011 08:54:08 +0700
Subject: RE: [belajar-excel] Tanya: merapikan tabel dengan makro
sori , ada yang ketinggalan yaitu Call formatisi .Range("A" & barisawal
& ":K" & barisakhir).SelectCall formatisi
' summary
To: belajar-excel@yahoogroups.com
From: jkss...@live.com
Date: Thu, 23 Jun 2011 08:47:20 +0700
Subject: RE: [belajar-excel
ADF
Periode
From
5/1/2011
Periode
To
5/31/2011
Company
20
Toko A
Dept Name
HRD
5 matches
Mail list logo