Tag: Excel Automation

Count Words in Spreadsheet in Excel VBA

How to use Like Operator in Excel VBA?

How to Copy File or Workbook in Excel VBA?

How to Use the Immediate Window in Excel VBA?

How to Change Background Colors of Cells in Excel VBA?

Delete and Clear Worksheet in Excel VBA

Convert String to Proper Case in Excel VBA

How to Add a Macro to the Toolbar in Excel?

How to Get Sheet Name in Excel VBA?

How to Clear Cells in Excel VBA?

How to Remove Characters from Left/Right of String in Excel VBA?

How to Get Active Cell Column and Row in Excel VBA?

Protect & Unprotect Worksheets in Excel VBA

How to Set Column Properties in Excel VBA?

How to Copy Worksheets in Excel VBA?

How to use Union and Intersect in Excel VBA?

How to Concatenate Strings in Excel VBA?

How to Copy a Range of Cells to Other Worksheets in Excel?

person holding blue and clear ballpoint pen

How to Insert Row or Column in Excel VBA?

How to Password Protect an Excel Macro?