2013-12-25
VBA Hello World - Excel Macro - For Beginners
Get easy step by step guide to code a Excel Vba hello world program. It is perfect place to start Excel Programming for beginners. 1. Excel VBA "Hello World" Ma...
Category: VBA Beginners
Showing all 25 articles in this category.
2014-01-04
How to Create a Macro in Excel 2010, 2007 & Above
What is a macro in excel? This is a fine option that can be used to learn Excel VBA Macro . When the "Record Macro" in switched ON: Manual operation done to exc...
2014-04-25
Excel VBA - Import Data from another Workbook - 4 Easy Ways
Excel Import Data From Another Workbook - VBA Codes To pull data from an external Excel file, use on of these scenarios. Closed Excel file: Using VBA Import dat...
2014-05-07
Find Synonym for Selected Text using MS Word VBA
How do we refer Synonym for a word usually? Dictionary - Find Synonym For Word To view synonym of a text in MS Word, We have to place the cursor on the word, th...
2014-06-18
Excel VBA Text To Speech - Voice Application Activation
Activate VBA Text to Speech (TTS) in Excel In this article you will learn about these topics related to TTS in Excel. Install Text to Speech (TTS - SAPI Windows...
2014-07-14
Making SORT More Simple and Faster in Excel with Advanced Options
Usual Sorting of Data or Table in Excel To Sort a Column Data in Excel, the user has to select the data range or column and then choose option “Sort & Filter”. ...
2014-07-22
VBA Code - Create Index of Worksheets - with Links to each Sheet
Index: Create List of Worksheet Names with Hyperlinks Ever came across this question !!! What is the maximum limit for number of sheets in Excel? Answer is: The...
2015-04-12
How to do VLOOKUP?
Macro for Vlookup Tutorial A Vlookup function search for ‘value’ in the first column of ‘table Range’ & returns a value from the same row. Syntax: =Vlookup (‘va...
2015-08-11
#N/A Error In Excel - Generate, Analyze & Exclude
Making of #N/A Error & Solve it If You are an Frequent MS Excel User, then you should have seen those Unexpected return codes from Formula that start with Hash(...
2015-12-06
Search for Value in Table using Beyond Vlookup
Excel Functions Vs Array Formula In this article, we are going to search for value in a Excel table without using Vlookup function. The formula that we are goin...
2015-12-07
How To Subtract in Excel?
How to Subtract Numbers in Excel? There is no built in function in Excel to perform subtraction. Use one of the methods explained below. In Excel, we could perf...
2015-12-30
Pick Multiple Columns using Random Numbers in Excel
In one of the earlier topics we learned how to generate Random numbers in Excel & Google Spreadsheet . Now, we will see how to get values from Random Columns us...
2016-01-19
VBA Macro Import - Read XML File into Excel - 5 Easy Tips
Convert XML Files to Excel - 5 Methods to Import To Import XML data to Excel you can use any of these listed methods. VBA to import XML to Excel Quick VBA to Co...
2016-05-03
Learn How To Code JavaScript in VBA
JavaScript Functions With in VBA: The Merger Include a reference to ‘Microsoft Script Control 1.0’ as explained below, before proceeding with further JavaScript...
2016-07-28
This Tiny VBA Can Send Email to All contacts in Your Outlook
How to Send email to all contacts in Outlook? Use one of the following methods to send Email blast from Outlook. i.e., mass email in Outlook to a large audience...
2016-08-13
Send Email from Excel with Attachment using vba
How to Automate Emails From Excel? Get macro to send email from Excel & email Excel file as attachment using VBA. In this page, you will learn and get code for ...
2017-12-06
Excel VBA - Convert Range To Array - 2 Dimentional
VBA Range to 2D Array These list of topics are covered in this page. Vba Code to initialize 2D Array with Range Vba to write Array data to worksheet Resize Arra...
2017-12-14
Excel VBA - Copy Workbook - Active or External
Excel VBA - Copy Active Workbook Get syntax for vba function to copy active workbook or external workbook saved in the folder. For both these purpose, we will b...
2018-02-27
Excel VBA - Convert Column Number to English Alphabet Letter
Column Number to Alphabet Letter Get vba code & Excel formula to get Column letter from column number, in here. For example, If you pass '1' to the function in ...
2018-02-27
Excel VBA - Convert Column Letter to Number
Column Letter to Number For each cell in worksheet the address will have column Letter and then Row number. For example: A1, B1, C1, etc., There is another repr...
2018-02-27
How To Type Subscript in Excel - Superscript Options - Excel VBA Code
Excel Subscript & Superscript Subscript or superscript are mostly used in scientific notation or in Chemical equations. Like: E = MC 2 . 2 as super script to me...
2019-07-28
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 o...
2020-01-16
VBA - Add Items to Array - Dynamic Resize without erasing data
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 ...
2020-07-15
Regular Expressions - I
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 ...
2022-04-06
VBA to open or save Word document Protected or Encrypted with password
Word Document Password Protection - 2 most used Methods Yes, there are more than one methods available to password protect a Word document. And it confused the ...