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іс […]
How to reset the VBE windows to their default positions
If you have some troubles with macro and projects explorer windows settings, after some bad manipulations. How to reset the VBE windows […]
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 […]