Get VBA code to sort a listview column header on click. Not only default column, any column in listview can be sorted, with a click on column header.
VBA to open or save Word document Protected or Encrypted with password
November 21, 2024
Use this VBA code to password protect or unprotect the Word document while openening the file. This macro also handles readonly protection, Write protection etc., right within the code itself.
Regular Expressions – I
November 21, 2024
A regular expression (shortened as regex) is an extremely useful way of matching common patterns and texts such as emails, phone numbers, URLs etc. almost all programming languages have a regular expressions library. It is widely used in text editors also to find patterns and replace string patterns that we specify in the […]
VBA – Add Items to Array – Dynamic Resize without erasing data
November 21, 2024
How to add new item to existing array? In VBA, an array is always an fixed size of data values. If you have to add new item, then size of the field also has to be changed. Lets see an example: Consider you have an array like the below one: […]
Rearrange Excel Sheets in Custom or Alphabetic Order with VBA
Custom Order or Alphabetical Order This page has VBA code that can arrange worksheets in a Excel file in: Custom Order as per user preference Alphabetic Order of the Sheet Names Lets get the code. VBA Code – Arrange Sheets in Custom Order To make the below code work, You […]
How To Type Subscript in Excel – Superscript Options – Excel VBA Code
How to type a subscript in Excel. Also learn to type a superscript for a part of text. This page also has macro code to convert a part of text in Excel to be subscript, superscript or strikethrough
Excel VBA – Convert Column Letter to Number
Get Excel VBA code to convert Column Letter to number. The Formula & Excel vba code will get column alphabet letter & return the Column number as value.
Excel VBA – Convert Column Number to English Alphabet Letter
Get Excel vba code & formula to convert column number to letter. Use this function in Excel worksheet or vba macro to get column letter from its column number.
Excel VBA – Copy Workbook – Active or External
Copy Active workbook or any workbook from external path using the inbuilt Excel function workbook.savecopyas. Make a Excel workbook copy to new path.
Excel VBA – Convert Range To Array – 2 Dimentional
November 21, 2024
Get Excel VBA Convert a Range to Array code in a Excel Workbook. And also write the array value to a worksheet range. Learn how to use of Resize & Transpose functions.