Senin, 08 November 2021

Resize Melompat 


Sub test()

Range("B3:C3").Select
Selection.Offset(2, 2).Resize(Selection.Rows.Count + 2, Selection.Columns.Count + 1).Select


End Sub
di
Label:

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)

Menghitung USIA Excel

=BYROW(D2:D100; LAMBDA(tanggal_lahir;     IF(tanggal_lahir=""; "";         DATEDIF(tanggal_lahir; TODAY(); "y"...

  • Modul VBA
     klik di sni
  • Immediate
    ?worksheets.count  5  ========================  selection.offset (15,0).select ======================= selection.copy selection.offset (2,0)...
  • Modul Cetak_Tab_Setoran
    Option Explicit Sub cetaktabungansetoran() Dim rujukan As Range Dim b As Long Set rujukan = Sheets("CETAKTABUNGAN").Range(...