RE: [Programmer-VB] ubah property excel

[Sistyo Alfan Tribowo]

'pakai ini Columns("E:E").EntireColumn.AutoFit 'atau ini Columns("E:E").ColumnWidth = 13.14   kalau diketahui index kolomnya.. cari addressnya dulu : misal kolom E index = 5   intCol=5 sAD = cells(1,intCol).address ' E1 sAD = left(sAD,len(sAD)-1) 'E 'terus ini Columns(sAD & ":" & sAD).EntireColumn.AutoFit 'atau ini Columns(sAD & ":" & sAD).ColumnWidth = 13.14         From: Programmer-VB@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of nurfirman Sent: 17 February 2006 16:26 To: Programmer-VB@yahoogroups.com Subject: [Programmer-VB] ubah property excel   Gimana caranya mengubah properti width colom i excel pake vb yang gw tau Columns($A:,$A:).autofit ada yang laen nggak yah... Gw perlu buat eksport dari ADo to Excel tengkiu Wahana Programmer Groups Links <*> Untuk mengunjungi sponsor milis ini, klik link berikut:     http://wahanaprogrammer.net <*> Untuk menghubungi owner milis ini, kirim email ke:     [EMAIL PROTECTED] <*> Konsultasi pemrogramman bisa chat disini:     Yahoo! Messenger: wahanaprogrammer SPONSORED LINKS Programmer Indonesia Basic programming language Computer programming languages Programming languages Java programming language YAHOO! GROUPS LINKS  Visit your group "Programmer-VB" on the web.    To unsubscribe from this group, send an email to:  [EMAIL PROTECTED]    Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.