Skip to content

BharatA Net

Partner Your Business to Publish Easier

Menu
  • Home
  • Jasa Pembuatan Website
  • Jasa SEO Indonesia
  • Jasa Video Profile
  • About
  • Contact

Kumpulan Tips Trik Excel Macro

Excel Macro itu asik, bisa memudahkan pekerjaan sehari-hari. Bagaimana caranya? Ikuti saja tips trik yang ada di halaman ini. Belajar terus dengan penuh semangat. Jika ada yang kurang atau pertanyaan, silakan tulis di kolom komentar ya. Share juga jika halaman ini bermanfaat.

Kumpulan VBA Excel Macro

Excel Macro : Hide Baris dan Kolom

Range("A1").Select
Selection.EntireRow.Hidden = True

Columns("M:P").Select
Selection.EntireColumn.Hidden = True

ActiveCell.Formula = "=IF(ISERROR(H" & baca_baris & "/$H$" & DR_urut_tot & "),"""",H" & baca_baris & "/$H$" & DR_urut_tot & ")"

Excel Macro : Copy Paste Format

Range("G610:L610").Select
    Selection.Copy
    Range("G619").Select
    Selection.PasteSpecial Paste:=xlPasteFormats, Operation:=xlNone, _
        SkipBlanks:=False, Transpose:=False
    Application.CutCopyMode = False


Worksheets("Sheet1").Range("A1").Formula = "IF(Sheet1!A1=0,"""",Sheet1!A1)" 

Excel Macro : Double Quote In Formula

Worksheets("Sheet1").Range("A1").Formula = "IF(Sheet1!A1=0,"""",Sheet1!A1)" 


Recent Posts

  • Jasa Company Profile
  • Jasa Video Profile Kegiatan Marketing
  • SEO Agency Indonesia
  • Jasa SEO Indonesia, 7 Awesome Tips
  • Jasa Web Design Profesional: Gift 5 Poin Basic Penting

Recent Comments

No comments to show.

Archives

  • June 2022
  • May 2022
  • April 2022

Categories

  • Uncategorized
  • web design

BharatA Net 2023 . Powered by WordPress