Excel Macro: Base64 HMAC Encryption
Some APIs require each REST request to be signed with an HMAC SHA256 signature, and these signatures need to be converted to […]
Excel Macro: Convert Current System Time to ISO 8601 UTC Time Stamp
The Excel VBA Now function is a built-in function in Excel that return the current system date and time, but not contains […]
Excel Macro: Sort Column Data By Double Clicking Header Cell
If you want to sort the column data in ascending or descending order by double clicking on any Excel column header, you […]
Reference cells and ranges
Programming with Excel VBA: The method of reference cells and ranges. Take this free course now!
Excel Macro: Delete Blank or Empty Rows
Blank rows can often cause problems with formulas. This macro can help automate delete blank or empty rows. Get this VBA code now!
Excel Macro: Delete Blank or Empty Columns
Blank columns can often cause problems with formulas. this macro can help automate delete blank columns. Get this VBA code now!
Excel Macro: Insert Blank Rows Between Existing Rows
If you need to insert blank rows between each of the existing rows into your Worksheet with VBA, this macro will help you to do this.
Writing data to files
When working with large amounts of data, it is often convenient to write data to or read data from a file. The […]
Excel Macro: Loop Through a List of Data
When you write a VBA Macro, you may have to loop through a list of data on a worksheet, this is one of VBA's must-have skills. Get it now!
Excel Macro: Enable Trust Access to the VBA Project Object Model
Enabling trust access to the VBA project object model allows you to write automated Excel programs and manipulate the VBA environment and […]
Programmatic access to Visual Basic Project is not trusted
Symptoms When I run an Excel macro, I get an error message: Run-time error'1004: Programmatic access to Visual Basic Project is not […]
Writing executable statements
An executable statement initiates action. It can execute a method or function, and it can loop or branch through blocks of code. […]