More Than 10 Ways to Speed Up Macros

"All roads lead to Rome", the same task can also be accomplished in different ways in VBA. When starting to learn programming, […]

Excel VBA: Convert Roman Numbers and Arabic Numbers to Each Other

Sometimes іt’ѕ rеаllу hard tо undеrѕtаnd Rоmаn numbеrѕ аѕ ѕеrіаl numbеrѕ. Thіѕ соdе will help уоu tо convert roman numbеrѕ to Arаbіс […]

Excel VBA: Copy and Paste a Range

One of the most common action you’ll need to learn is copying and pasting a range of data. It’s very easy to […]

How to disable "There's already data here. Do you want to replace it?" warning

When you drag any cell with data and drop it on any other cell with data, you will get the warning, "There's […]

Excel VBA: Limit The Number Of Times Workbooks Can Be Used

Suppose you want to send a demo file for users to check, but you don't want it to be used more than […]

Excel VBA: How To Remove Document Inspector Warning Include Personal Information

You may get warning message about the Document Inspector when you want to save Excel file. Is there a script can remove […]

EXCEL VBA Convert Current System Time to ISO 8601 UTC Time Stamp (with Milliseconds)

The Excel VBA NOW function is a built-in function in Excel that return the current system date and time, but not contains […]

Excel VBA Base64 HMAC SHA256 and SHA1 Encryption

VBA Base64 HMAC SHA256 and SHA1 To use this code, you need do this: Inside the VBE, Go to Tools -> References, […]