Terimakasih Mas Kid, Behasil !!! Wassalam -zainul
From: [email protected] [mailto:[email protected]] Sent: Thursday, September 25, 2014 4:06 PM To: BeExcel Subject: Re: [belajar-excel] Error: "Unable to set the LineStyle property of the Border class" saat setting conditional format lewat VBA Mas Zain, coba pakai xltop saja daripada xledgetop Wassalam, Kid. 2014-09-25 17:30 GMT+10:00 'zainul_ulum[at]yahoo[dot]com' [email protected] [belajar-excel] <[email protected]>: Be-Excelers, Saya membuat object FormatCondition bernama fmtCondPlan. FormatCondition saya atur formula dan stylenya sbb: (complete code vba ada di file terlampir) '================================================================================================= Set fmtCondPlan = rgData.FormatConditions.Add(Type:=xlExpression, Formula1:="=" & strCondPlan) With fmtCondPlan .Interior.Color = rgbAquamarine .Borders.LineStyle = xlContinuous 'note #1 '.Borders(xlEdgeTop).LineStyle = xlContinuous 'note #2 End With '================================================================================================== Saat baris note#2 saya non-active kan, program berjalan dengan baik, tetapi jika note#1 saya non activekan dan note#2 saya aktifkan muncul pesan error "Unable to set the LineStyle property of the Border class". Hasil yang diharapkan adalah pada baris Rencana: Ada garis continuos di atas, sedangkan pada baris Aktual: ada garis putus-putus. Mohon pencerahan solusinya. terimakasih -zainul
