Hello, Terimakasih atas share-nya . Salam, Nyom2
----- Original Message ----- From: Katro Boy To: [email protected] Sent: Wednesday, June 04, 2008 4:08 PM Subject: Re: [Programmer-VB] Format XLS->properti boder ??? Bisa seperti ini: With vExcel.Worksheets("Sheet1") Worksheets("Sheet1").Activate .Cells(1, 1).Value = "TEST": .Cells(1, 1).Font.Bold = True .Cells(2, 1).Value = "FORMAT BORDER EXCEL" .Cells(1, 2).Value = "XXXXX" .Cells(2, 2).Value = "YYY" .Range(.Cells(1, 1), _ .Cells(2, 2)).Borders.LineStyle = xlHairline .Rows(1).RowHeight = 25 .Columns("A").ColumnWidth = 30 End With .vbp nya bisa didownload di Blog saya : http://katroboy.wordpress.com/ Thanks Nyom2 Denpasar wrote: > Maaf melanjutkan yg sebelumnya, saya sudah dapat link untuk memformat > cell Excel. Bila ada yg punya info, bagaimana memformat boder , > ketingguan rows, maupun lebar kolom ya.....di site tsb tidak ada, dan > saya cari2 di link yang lain belum menemukan. > > Tengkyu, ada yg punya referensi lain ?? > > salam, > nyom2 > ------------------------------------------------------------------------------ No virus found in this incoming message. Checked by AVG. Version: 7.5.524 / Virus Database: 269.24.6/1480 - Release Date: 6/3/2008 7:00 AM
