Kalau boleh urun rembug....
Untuk menghemat kertas selama uji coba, Code ini :
ActiveSheet.PrintOut From:=1, to:=1,
_
Copies:=1, Collate:=True
bisa diganti dengan
ActiveSheet.PrintPreview
Salam,
Hendrik Karnadi
From: Muhammad Ferdiansyah <[email protected]>
To: [email protected]
Sent: Tuesday, 29 January 2013, 14:55
Subject: RE: [belajar-excel] print dengan continous form
Maaf om, kita bukan master, hanya user yg iseng” nyoba.. J
Oh, ternyata saya baru menangkap apa yg dimaksud..:D
Untuk cell I2 (no sj cetak), adalah jumlah SJ yg akan di cetak?
Sedangkan jika data yg dicetak lebih dari 1 halaman maka akan
mengeprint sesuai jumlah halamannya ya om?
Berarti harus diotak-atik lagi..
File terlampir.
Semoga tepat sasaran..
hehe
From:
[email protected] [mailto:[email protected]] On
Behalf Of vincent Yoes
Sent: Tuesday, January 29, 2013 1:10 PM
To: [email protected]
Subject: Re: [belajar-excel] print dengan continous form
Sent: Tuesday, January 29, 2013 1:10 PM
To: [email protected]
Subject: Re: [belajar-excel] print dengan continous form
thanks to master M.Ferdiansyah
berarti yang tercetak by page ya...
kalo untuk no SJ 2 cara nyambunginnya gimana ya.....
thanks
berarti yang tercetak by page ya...
kalo untuk no SJ 2 cara nyambunginnya gimana ya.....
thanks
From: M.
Ferdiansyah <[email protected]>
To: [email protected]
Sent: Monday, January 28, 2013 9:43 PM
Subject: Re: [belajar-excel] print dengan continous form
To: [email protected]
Sent: Monday, January 28, 2013 9:43 PM
Subject: Re: [belajar-excel] print dengan continous form
Iseng"
otak-atik formulanya saja..
file terlampir.
Maaf kl salah.
:)
>
>
> Dear Master VBA excel
> mohon bantuannya
>
> saya mau print ini di form cetakan ternyata jumlah item barang terlalu
> banyak
> dan membutuhkan lembar ke dua dengan no sj yg sama.
> gimana ya biar otomatisasinya bisa continous tidak terputus…???
> Mohon pencerahannya para MASTER VBAÂ Â
>
>
> saya sertakan juga sampe form-nya
>
> Terima Kasih
____________ _________ _________ _________ _________ _________ _________
Notice : This e-mail (and any attachment) is strictly confidential and
is intended only for the addressee(s)above. Is strictly prohibited to
forward, print, copy, or otherwise reproduce this message that would
allow it to be viewed by any individual not originally listed as
a recipient(s). If you have received this e-mail in error, please
immediately notify the sender and delete this message. The opinions
expressed in this e-mail (and any attachment) are those of the individual
sender and may not necessarily reflect the views of PT Pusri.
____________ _________ _________ _________ _________ _________ _________
file terlampir.
Maaf kl salah.
:)
>
>
> Dear Master VBA excel
> mohon bantuannya
>
> saya mau print ini di form cetakan ternyata jumlah item barang terlalu
> banyak
> dan membutuhkan lembar ke dua dengan no sj yg sama.
> gimana ya biar otomatisasinya bisa continous tidak terputus…???
> Mohon pencerahannya para MASTER VBAÂ Â
>
>
> saya sertakan juga sampe form-nya
>
> Terima Kasih
____________ _________ _________ _________ _________ _________ _________
Notice : This e-mail (and any attachment) is strictly confidential and
is intended only for the addressee(s)above. Is strictly prohibited to
forward, print, copy, or otherwise reproduce this message that would
allow it to be viewed by any individual not originally listed as
a recipient(s). If you have received this e-mail in error, please
immediately notify the sender and delete this message. The opinions
expressed in this e-mail (and any attachment) are those of the individual
sender and may not necessarily reflect the views of PT Pusri.
____________ _________ _________ _________ _________ _________ _________
