[belajar-excel] Mohon buatkan kode [2 Attachments]

classic Classic list List threaded Threaded
4 messages Options
Reply | Threaded
Open this post in threaded view
|

[belajar-excel] Mohon buatkan kode [2 Attachments]

praglasa
Bingun gak bisa bisa....mohon solosinya para suhu
pada gambar (1) d2 berisi validasi data dan D3& d4 hasil vlookupPada cell
J4 berisi =Today(), ketika disave syan ining tanggal tsb  tersimpan di data
base range (D2 : d6).
Maksih

gbr. 1.jpg (37K) Download Attachment
gbr. 2.jpg (35K) Download Attachment
Reply | Threaded
Open this post in threaded view
|

Re: [belajar-excel] Mohon buatkan kode [1 Attachment]

cahayailmu71
Coba ini Pak.

On Thu, Jul 23, 2020 at 4:45 PM pragaan laoksatu [hidden email]
[belajar-excel] <[hidden email]> wrote:

>
>
> Bingun gak bisa bisa....mohon solosinya para suhu
> pada gambar (1) d2 berisi validasi data dan D3& d4 hasil vlookupPada cell
> J4 berisi =Today(), ketika disave syan ining tanggal tsb  tersimpan di data
> base range (D2 : d6).
> Maksih
>
>
>

PragaanLaok1.xlsm (27K) Download Attachment
Reply | Threaded
Open this post in threaded view
|

Re: [belajar-excel] Mohon buatkan kode

praglasa
Mantap suhu...dan saya coba berulang-ulang ..sukses...kalo sekalian
terprint gimana suhu ?

On Thu, Jul 23, 2020 at 8:53 PM Cari Kebenaran [hidden email]
[belajar-excel] <[hidden email]> wrote:

>
>
> Coba ini Pak.
>
> On Thu, Jul 23, 2020 at 4:45 PM pragaan laoksatu [hidden email]
> [belajar-excel] <[hidden email]> wrote:
>
>>
>>
>> Bingun gak bisa bisa....mohon solosinya para suhu
>> pada gambar (1) d2 berisi validasi data dan D3& d4 hasil vlookupPada cell
>> J4 berisi =Today(), ketika disave syan ining tanggal tsb  tersimpan di data
>> base range (D2 : d6).
>> Maksih
>>
>>
>
Reply | Threaded
Open this post in threaded view
|

Re: [belajar-excel] Mohon buatkan kode

hendrik karnadi
 Kalau yang mau di Print --> Sheet Print.Range("B2:G5"), tambahkan saja perintah ini sebelum End Sub..Sheets("Print").Range("B2:G5").PrintOut

Salam,HK


    Pada Jumat, 24 Juli 2020 12.46.43 GMT+7, pragaan laoksatu [hidden email] [belajar-excel] <[hidden email]> menulis:  
 
    

Mantap suhu...dan saya coba berulang-ulang ..sukses...kalo sekalian terprint gimana suhu ?
On Thu, Jul 23, 2020 at 8:53 PM Cari Kebenaran [hidden email] [belajar-excel] <[hidden email]> wrote:

    

Coba ini Pak. 
On Thu, Jul 23, 2020 at 4:45 PM pragaan laoksatu [hidden email] [belajar-excel] <[hidden email]> wrote:

    

Bingun gak bisa bisa....mohon solosinya para suhupada gambar (1) d2 berisi validasi data dan D3& d4 hasil vlookupPada cell J4 berisi =Today(), ketika disave syan ining tanggal tsb  tersimpan di data base range (D2 : d6). Maksih