RE: [belajar-excel] Tanya: merapikan tabel dengan makro

2011-06-23 Thread Santi Rosaindah
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 ---

RE: [belajar-excel] Tanya: merapikan tabel dengan makro

2011-06-22 Thread Sudarsono Suhenk
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

RE: [belajar-excel] Tanya: merapikan tabel dengan makro

2011-06-22 Thread Sudarsono Suhenk
= "=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

RE: [belajar-excel] Tanya: merapikan tabel dengan makro

2011-06-22 Thread Sudarsono Suhenk
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

RE: [belajar-excel] Tanya: merapikan tabel dengan makro

2011-06-22 Thread Sudarsono Suhenk
ADF Periode From 5/1/2011 Periode To 5/31/2011 Company 20 Toko A Dept Name HRD