2013-12-25
How to Remove Duplicate values in Excel?
Remove Duplicates in Excel Worksheet To remove duplicate values in Excel, follow these steps. Open the Excel Workbook. Select the Range of values that has dupli...
Category: Excel
Showing all 188 articles in this category.
2013-12-28
Insert Calendar Control - In Excel Worksheet - Date Picker
Insert Excel Calendar Control or Date Picker The steps to insert a Calendar control differs for Excel 34 bit & 64 Bit versions. Check Excel Version: To know whe...
2013-12-28
Working With Calendar Control In Excel Worksheets
1. To know how to insert the Calendar Control in worksheet, read the below topic. /insert-calendar-control-in-worksheet/ 2. After inserting, how to get the valu...
2013-12-30
Send Mass Email from Excel VBA 1.3 - Multiple Recipients - In Outlook
How To Send Bulk Email From Outlook Using Excel? Learn the best ways on how to send email from Excel VBA to multiple recipients here. Download "Send Mass Email ...
2013-12-30
How To Insert Command Button - In Excel Sheet - Developer Tab?
1. Add Excel Command Button from Quick Access Toolbar This is Applicable for Excel 2007 and above versions. This page has quick tips to insert command button in...
2013-12-31
Removing Empty Folder is Now Easy - Get Folder List with Size
Get Folder List with VBA Dir - Remove Empty Folders To get the list of folders within a folder through VBA, it would have been nice if the command name is VBA D...
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-01-06
Excel VBA Timer Event - Run Macro at Specific Time - Automatic Schedule
Excel VBA Schedule Macro to Run at Specific Time Here you will learn - How to add Excel VBA Timer Event to run macro automatically at certain time & how to crea...
2014-01-17
Reading Process List From Task Manager
How to Import application list from Task Manager to Excel? Well, this can be done with the help of the Windows API Function from the library Kernel32. Using thi...
2014-01-17
VBA Code - To extract data - From website to Excel Macro
VBA Code to Extract Data from Website to Excel To perform HTML screen scrapping or get webpage data into Excel using VBA code, read these easy tips. Programmers...
2014-01-26
Run Macro When Cell Value Changes or Range VBA
Call Macro if Cell Value Changes Learn how to create a VBA Range macro to run when any specific cell value changes. Also we don't have to explicit use any User ...
2014-02-14
Excel To VCF Converter - 81,000+ Downloaded - Excel To Vcard App
Converting Excel to VCF with Just One Click To convert CSV or Excel To VCF, follow these simple instructions: Download & Open Excel to vCard file converter app....
2014-02-27
Convert Excel String To Date - VBA Date Format
Convert Text To Date in Excel or Number For Excel date format conversion manual or VBA follow these 2 methods. Excel automatically converts the data types to it...
2014-02-28
Excel Vba For Each VBA If Else Switch Case
Excel VBA IF Else - For Each After the Hello World program, there was no topics posted for beginners in OfficeTricks. So here is one that would benefit the lear...
2014-03-04
Excel Convert - Number To Date - VBA Date Format
How to Change Excel Date Format? Excel date format related function are grouped in Menu-> Formula -> Date & Time Option. Using this, we can get today's date & t...
2014-03-18
Remove Junk Characters In Text File - Excel Trim Just Not Helping
Excel Trim Not Working - Remove Unwanted Characters Is Your Excel function TRIM not able to remove non-displayable characters? A Trim function will remove only ...
2014-03-29
VCF to Excel Converter - VBA Code to Read vCard File
How To Convert VCF To Excel? To convert contacts in VCF to Excel, You can use one of these methods. Download our vCard to Excel App Excel VBA Conversion Code - ...
2014-04-12
Excel VBA - Get RGB Color of Cell - Change Background
VBA to get Excel Cell Background Color RGB Code & Change it Hope you would like these in-depth Excel cell color formatting techniques. In Excel macro to get cel...
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-26
Safe Password Manager - Secure All Your Passwords
Trouble Remembering Too Many Login Credentials - Password Management with Encryption This article explains some techniques on how to make your own password mana...
2014-05-24
Password Protect Excel 2010 & 2007
How To Password Protect Excel & Word Documents? The Article explains how to secure a document with built in options & then a corresponding VBA Code snippet. The...
2014-06-25
Excel VBA - FTP Transfer - Files Download Upload
Secure FTP Upload Thru Different Methods FTP automation is done to transfer data from PC or web server to a FTP file hosting service. Often this data is served ...
2014-06-27
Extract URL Links from Sitemap.xml file using Excel
About Sitemap.xml Sitemap XML file is used by the search engines to find out the complete list of the pages of the website. Along with url link of the page, it ...
2014-07-10
Login to Facebook, Twitter, Google+ in IE from Excel
Login Automatically into Social Media Networks in IE using Excel These days’ people spend too much time in Social Media Networks like Facebook, Twitter, and Goo...
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-19
How to Delete Blank Rows in Excel - Remove Empty Rows - 3 Easy Tips
1. Excel Delete Multiple Blank Rows (Built in Option) To remove blank rows in Excel, Open the worksheet & follow these menu options. Select data range that has ...
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...
2014-07-24
How to use Excel VBA Telnet To Autorun Commands?
Excel VBA Telnet Client for Remote Connect We use Telnet Client sessions to control or manage systems that does not have a keyboard or monitor attached to it. A...
2014-07-30
Import Mail IDs from Outlook Email to Excel
Fetch Email Addresses - Quick Install & Test Code Open MS Outlook and Select any mail in Inbox or any other Folder Open new Excel Workbook, Alt+F11, Copy Paste ...
2014-08-13
Email Extractor from Website or URL using Excel App
Email Address Harvesting Software To collect Email Ids from website, use this Mass Email extractor or Email harvesting software. This is mainly used by marketti...
2014-09-04
Archive Facebook Messages - JSON to Excel
Facebook Timeline - News Feeds - Wall Posts In this article, we are going to explain, How to use Facebook OpenGraph API to extract your FB data in JSON format? ...
2014-11-21
Convert CSV to Vcard File - Download Converter App
Conversion From CSV to VCF (or vCard) To convert a contacts from CSV to vCard file business contact format, use this easy tips. CSV stands for Comma Separated V...
2014-10-12
Excel Games Free Download - 2048 Tile Game
How to Play 2048 Game? 2048 game is played in the 4 x 4 tile. To play this game You need to use 4 arrow keys in the keyboard (top, right, bottom, left). With ea...
2014-11-14
Not a Secret Anymore - What is my IP Address Location? Bulk GeoIP Lookup
GeoIP to Location Lookup Database - Find Website IP Many websites and software provide free GeoIP - IP to location lookup services. If we input an IP address to...
2014-12-24
Mortgage Calculator - Loan EMI Scheduler - in Excel
Types of Mortgage Loan Interest Rates There are broadly two common types of interests in Mortgage Loans. In the first type, Interest is set to a Fixed rate of L...
2015-02-09
Create ListView in VBA at Runtime
Compatibility Issues working with Application in Older Version Of Office After the recent upgrades in Microsoft products, we can notice few compatibility issues...
2015-03-01
Word Mail Merge as Mass E-mail Marketing Services
Mail Merge with Excel and Word This is a Built in Option in Microsoft Word for sending personalized mails or letters, to a mass mailing list. If you have Micros...
2015-03-20
How To Scrap A Website Keywords? - Keyword Scraping Excel
Web Scraping & Keywords Analysis Tool - SEO Get the Excel with VBA code for Scraping Keywords from Website to help in your SEO tasks. Search Engine Optimization...
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-04-12
Android ICS File Viewer - Calendar file View in Exce;
.ics File Format (ICalendar) Events like meeting requests, tasks, alarms, to do list etc., are stored in Calendar application. This Calendar application could b...
2015-05-11
Convert Excel To PDF - VBA Code Print Selected Area
Excel VBA Print & Save as PDF Commands This article provides code for creating PDF from Excel & Vba print macro Excel 2010 or versions less than that. Just like...
2015-05-13
Excel Instant Messenger - Microsoft Office Communicator API Library
Auto Send Instant Office Communicator Message from Excel This article explains how to send instant messages to your friends through Excel. The code in this page...
2015-06-27
Application Monitor – Manage & Terminate - Tasks Manager
Task Manager in Excel - How to use Excel to Monitor Servers or PC? There are in built application in Windows to view what applications are currently running in ...
2015-08-07
Compare Two Excel Sheets - Highlight Differences - Macro VBA Code
How to Compare Two Excel Sheets for Differences? How do you compare Excel Spreadsheets? To assure quality of a software, compare Excel files as explained below....
2015-08-12
Create Random Numbers in Excel and Google SpreadSheets
Random Numbers in Excel Formula, VBA & SpreadSheets Is it any Guessing Game? Yes. If you can predict the next number these functions can generate then, Microsof...
2015-08-21
Software Downloads From Our App Store - Try Free & Buy
Indian Users can buy products from this link . International Users can buy from below links. Read our Terms & Conditions at end of this page before purchasing. ...
2015-09-04
UnLock Protected Excel Sheet - Remove Password to Unprotect
Unprotect Excel Sheet - Without Knowing Password Get VBA Macro code in this page, that will help you to generate an alternate password to un-protect Excel sheet...
2015-09-15
Lock a Folder - In Windows - Excel Folder Lock Code
How to Lock a Folder in Windows 7 or Above? Microsoft keeps on upgrading its Windows Operating System consistently to improve User experience and Security. Thes...
2015-11-05
Hide Desktop Icons of Active Windows Applications
How To Hide Desktop Icons of Active Apps? As the name suggests the Windows Operating System executes the application as different Windows. User sees the Desktop...
2015-12-06
How to Add Numbers in Excel using Different Methods
How to Add in Excel? Open Excel Workbook and follow the steps mentioned below. Select Range of Cells that you want Sum in Excel sheet & Click ‘AutoSum’ in Home ...
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-21
Sudoku Excel Download - Puzzle Solver - Free Game Help
Sudoku Solver - Excel Games Puzzle Sudoku is one of the famous Math games that will test your memory capability. Here is the list of instructions about how to p...
2015-12-31
Printable 2022 Calendar Excel - Month Wise Template
Printable Excel Calendar 2022 Template To get yearly printable calendar template in Excel for any year, use our free download or follow these steps. Most of 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-01-31
Convert Kg to Lbs - Feet To Meters, Miles - Liter to Gallon
Engineering Unit Conversion Table In Excel If you want to convert kg to lbs, meter to feet or liter to gallon -this Engineering Unit Converter Excel app can per...
2016-02-07
Non Repeating Unique Random Numbers - Fun with Excel
Non-Repeating Numbers - With Excel RND function In Excel VBA or any programming language we have built in function to generate random number. But it will genera...
2016-02-11
Universal VCF to Excel and Excel to Vcard Converter
What this VCF converter Can Do? Get this VCF to Excel Universal converter, to perform the below listed operations. Convert any VCF file to Excel with no limitat...
2016-06-16
How To - Export Facebook Contacts To Excel - using Yahoo mail?
Export Contacts from Facebook to Excel To export Facebook contacts to Excel with email addresses or CSV/vCard (.vcf) format use this trick. Facebook contacts to...
2016-04-06
VBA To Copy Visible Cells Only and Paste in Excel
Excel VBA To Select & Copy Visible Cells In Excel, sometimes few rows wont be in visible state, when auto-filter is enabled or made hidden by any user. In such ...
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 ...
2016-08-18
How to Get stock prices in Excel? – Best Live Stock Ticker
Get Stock Quotes in Excel Use this simple technique to get free stock market data as an Excel stock price list. Have you been a stock market investor dumping a ...
2016-08-26
Convert a Formatted Cell in Excel into HTML Tag using VBA
Convert Formatted Cell in Excel to HTML To get the font and formatting style of a text in worksheet follow these methods. Excel Worksheet Cell format – Single F...
2016-09-09
Excel Import Data - From another Workbook - Query External Source
Import Data from Excel to Excel To pull data from another workbook to current active Excel, try these methods. Data Import option to query data from another wor...
2016-09-15
Excel VBA Check - IF String Contains - Only Letters
Check IF VBA String Contains Letters or Alphanumeric There is no string operator or function that performs VBA check if string contains only letters. There is w...
2016-09-16
VBA to Create Email List using Excel - Distribution List
VBA to Add Semicolon to Email Addresses in Excel If you have Email Ids in Excel, then create distribution list using this app or VBA code. We come across situat...
2016-10-21
Convert VBA Declare Compatible with 64 Bit Office
Convert Excel VBA 32 Bit to 64 Bit To solve Compile error: 'The code in this project must be updated for use on 64-bit systems', continue reading If you upgrade...
2016-11-01
How to create Drop down data validation list in Excel?
1. Add Drop down list with Excel Data validation? A data validation list in Excel enable users to choose only predefined values from a drop down option. If user...
2016-11-10
Excel Vba RGB to Hex,Long - Hex to Rgb,Long - Color Code Conversions
Convert VBA Color Codes to RGB or HEX To convert the Excel vba color index list to RGB, HEX, Long/Decimal use these functions. This covers almost all type of Co...
2016-11-12
Excel VBA Color Index List - Worksheet Interior Font - Colour Codes
Excel VBA Color Index List Excel color index are used to change either a worksheet's background(Interior), font or border color. There are 56 colors that has pr...
2016-11-21
Excel Count Cells By Color - Using VBA ColorIndex - CountByColor
Excel Count Colored Cells with VBA ColorIndex To count colored cells in Excel using VBA color codes, use this code. This code will check for VBA color index in ...
2017-01-05
Compare Two Columns Excel - Highlight Match – Bulk Data Duplicates
Excel Compare Two Columns & Report Differences Learn how to compare multiple columns in Excel with huge volume of data. Find duplicate entry in 2 columns using ...
2017-02-05
Microsoft Excel - Show Developer Tab – Enable VBA Macro Option
Show Developer Tab Menu - Excel Office 2010 or Above To enable ‘Developer Tab' in the Menu for Excel & Word, this steps can be followed. Prerequisite: To enable...
2017-02-05
Consolidate Data - In Excel Files - Create Summary Report
Excel Consolidate Data Function To Summarize This option enables user to consolidate in Excel. Summarize data from different worksheets to one sheet. Data from ...
2017-02-05
Fibonacci Sequence Number Generator - Excel Easy Trick
What is the Fibonacci Number Sequence? Fibonacci series is a sequence of numbers. Any number in the list is a sum of last 2 numbers ahead of it (i.e., Last 2 pr...
2017-02-09
Pivot Chart In Excel - How To Create A Pivot Table?
In Excel - What is a Pivot Table? Pivot Table is used to consolidate or summarize a table with huge volume data. Pivot table or Pivot chart are very quick power...
2017-02-17
Add Insert Controls - To Excel Quick Access Toolbar - Activex & Form
How To Add Options to Quick Access Toolbar The steps will guide you to add controls or command to Quick Access Toolbar in Excel or Ms Word. 1. Click on “Customi...
2017-04-17
Copy Excel Chart in Powerpoint - Macro VBA pastespecial
How to Copy Excel Chart in PowerPoint Slides using VBA Macro - Step by Step Tutorial Requirement: We need to copy several charts from Excel in Powerpoint slides...
2017-10-10
VBA XML Parser - Read XML Nodes & Import To Excel
Read XML using Excel VBA XML is the file format that is widely used to transfer data over internet or between 2 systems with different platforms. The most widel...
2017-11-10
Open Text File - Read Write File Operations - VBA, Python, VBS, C, C++, DOS
File Operations - VBA, Python, VBS, C, C++ & DOS It is important for any programming language to open text file or get data from external file or write to a ext...
2017-12-05
Excel VBA - Get Extended File Property - Author Modified Date Time
Get File Property Using Excel VBA Try these code to get the property of a file in the computer folder. By file property, I mean the Username who created it, Fil...
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-06
Convert 2D Arary To 1D or List - Excel VBA Macro - Quickest Method
Convert Array of 2 Dimension to 1 Dimension In Excel VBA , we use 2D arrays quite often. This is because, we convert Excel Worksheet Range to Array and do the d...
2017-12-06
Excel VBA Sort Range - Columns Ascending - or Alphabetically
Excel VBA sorting Range of multiple Columns How to Sort a Excel range of data? Do it either thru VBA Sort Range code or Built-in menu option. I have presented b...
2017-12-07
Get List of All Subfolders in a Folder - Excel VBA
Excel VBA Dir - Directory Listing - All Subfolders The macro will fetch all subfolders & folders under subfolders till its last child folder. You just have to i...
2017-12-10
JSON Parser - Convert JSON To CSV - Excel VBA Macro
Parse JSON - Converter in Excel This name often reminds me of the film Jason Bourne . But this JSON is a file format standard. In this page, You can get JSON co...
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...
2017-12-21
VBA Macro to - Delete Shapes in Excel - Workbook Objects Boxes
Delete all Shapes in Excel Workbook In Excel a shape object can be: A square box, round, call outs, star, arrow, line etc., Do you want to clear all these shape...
2017-12-21
Determine Operating System - Excel VBA Macro - Find OS Details
OS Specific VBA Code Does your clients report OS related issues often? Sometimes, Yes. The Vba macro might end up in Microsoft 32 bit or 64 bit or a Mac IOS sys...
2017-12-26
VBA Macro - Choose Outlook Email Account - To Send Mass Mail
Choose From Multiple Outlook Email Accounts Marketing people send tons of emails daily, to their customer base. If a customer is not interested in the offer, th...
2018-01-07
Excel VBA - Attach Inline Image - To Outlook Email body
VBA - Insert Inline Image - Into Email Bo0dy Wondering how to attach inline images in Outlook email? It can be done by converting the default text or rich text ...
2018-01-07
Convert Excel to HTML Table Tags - VBA Macro Code
Excel to HTML Table Do you want to copy the Excel Table to a webpage? Most of the time, It is easy to represent data in table format. Excel spreadsheet is the o...
2018-01-09
Check If Outlook is Running - then Launch Outlook app - vba code
How to Test if Outlook is Open or not? Are you automating any task with Ms Outlook App? Then, sometimes, you need to verify that the Outlook is already running ...
2018-01-12
Create Keyboard Shortcut - to VBA Macro code - in Excel
How to assign keyboard shortcut to a vba macro? Not all Vba code needs a GUI. Some users love to run them using a shortcut key. How to create a vba macro keyboa...
2018-01-20
How to Run Macro - by Clicking Hyperlink - in Excel?
How to Assign a Macro - to a hyperlink in Excel? Did you just thought a button click or keyboard shortcut - are the only possible way. Run macro using hyperlink...
2018-02-25
How To Edit Worksheet in xlam - Excel Addin File?
Excel Add-in Files - Editing Sheets Excel add-in xlam or xla (2003 format) file is a collection of macros, that can be included in Excel app. Once add-in is ena...
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
Excel VBA - Merge Cells - Unmerge Range
In Excel macro, using the range or selection object, merge cells & unmerge operations can be done. Nothing much to explain in this. But just remember that: once...
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...
2018-03-15
Name Numerology Calculator - Lucky Number from Birthday - Excel App
Lucky Numbers & Numerology in Excel Numerology or Lucky number is calculated commonly using these 2 input methods. Person's Name Person's Date of Birth This pag...
2018-04-05
Excel VBA Convert SpellNumber - Amount (Numbers) To Words - Both US & India Formats
Amount in Numbers To Words - Both Million & Crores Get Amount converted from Number to Words both in Millions & Crores format. In many accounting, billing & inv...
2018-04-08
Excel Insert Button is Disabled - Greyed Out - How To Enable It?
Enable Greyed Insert Button in Excel Sometime the Row Insert or Column insert button get disabled/greyed out. Unsure of what happened. Here are few hints to bri...
2018-04-27
Excel VBA - Find UpperCase Word in String or Worksheet
Finding Uppercase Words in String? Use this direct method to find out whether any lengthy string has words with all Caps. For example: This line has one WORD as...
2018-05-04
Number of Working Days in a Year - Between Two Dates - Excel
Excel Formula - Calculate Number of Working Days This function is different from just Calculating the difference between Two dates. Here we will use the functio...
2018-05-06
Excel Add WorkDays To Date - Excluding Weekends & Holidays
Adding WeekDays to Date - Excel Formula & VBA Code This is helpful in planning duration for a project, budget or anything that is related to number of working d...
2018-05-07
Calculate Number of Days Between 2 Dates - Excel DateDiff
How To Find Number of days between Two Dates? Sometimes we need to know the exact time gap or days in between two consecutive years or months. Here you will fin...
2018-05-07
How to Split Date & Time - In Excel Worksheet?
Worksheet Date & Time - How to Split it? In worksheet type this function to get Time enter the formula '=Now()' . It will return the default value as today's da...
2018-05-09
Excel Compare Two Columns for Duplicates - Highlight Differences
Compare Columns & Highlight Duplicates or Unique Values Here is how you can compare multiple columns in Excel & change the background color for duplicate values...
2018-05-12
How to get Age from Date of Birth in Excel? - Formula & VBA
How to Get Age from Date of Birth (DOB)? The very easiest way to calculate person’s age from using their birthday in Excel is using this formula. Syntax: DATEDI...
2018-05-17
How To Find Smallest & Largest value in a Range in Excel?
Get Maximum & Minimum Values in Worksheet Range Sometimes, we need to find the max or min data in a worksheet. If there are a few data, you can easily get the d...
2018-08-17
Excel Custom Number Format- Change Currency To Indian Format
Convert Number Format or Currency Format This is something I learned today. One of my friends called me for a help. He has Excel sheet with numbers like this. 3...
2018-09-25
Python Program To Check Palindrome
Palindrome Program in Python Following Python code will check if a string is palindrome or not. Solution: Define string to check for palindrome. Create a functi...
2018-09-26
Excel VBA Loop Thru All Defined Names
Excel List All Defined Names with Formula Defined names are using to simply the long formula into a short & meaningful name. These names can be defined in Excel...
2018-09-26
Excel VBA - Create Defined Name Formula & How to Use
Creating Defined Name with Formula in Excel Defined names or Custom Formula are used to simply the long formula into a short & meaningful name. These names can ...
2018-11-29
Excel VBA - Copy Sheet To Another Workbook
Copy Worksheet to another Excel file VBA Command: Worksheet.copy You are working in an Excel file. You want to copy one of the sheets in the current workbook to...
2019-02-01
Enable Cut/Copy/Insert/Delete Options in Excel Right Click
Enable Grayed Option on Excel Right Click Does some of the options on the right click command bar is disabled or grayed out in your Excel Worksheets. Though it ...
2019-01-01
Enable Disable Excel Command-Bar Options
Excel - Enable Disable Commands & Options There are about 150+ options available with the code presented in this section. The notable options are "Status Bar" a...
2019-02-01
Python - Copy , Rename List of Files in Folder
CSV File List - Rename Files in Folder Using Python This is a simple code snippet that I developed for one my recent project. The current name of list of files ...
2019-02-02
List all Excel VBA Environment Variables - Username
Get VBA Environment Variables in Excel By VBA environment variables, it actually means the Windows system environment variables. These environment variables hav...
2019-06-19
Anagram Maker - Solver Free Download - Excel App
Anagram Solver Basic App This Anagram Maker app does not require any installation other than MS Excel. It requires MS Excel to be already installed with VBA mac...
2019-06-19
Excel VBA Check for Anagram words
Check if Two words are Anagram Anagrams are two or more different words with same combination of letters. For example: now, won, own How do we compare & verify ...
2019-06-25
VBA - Check for Active Internet Connection - Network Status
VBA Check if Computer is Connected to Network Is your Excel or other Ms office application is fetching data from Internet ? Do You also wish to check if the com...
2019-06-28
Highlight Duplicate Values in Excel with Color
1. Conditional Formatting: Highlight & Find Duplicates in Excel Find duplicate values in Excel files by using "Conditional Formatting" as explained below. Excel...
2019-07-10
How to do Spell Check in Excel?
What happens with spell check? First the spell check process will happen on current cell. The process will take each word in the cell for correct spelling. If a...
2019-07-13
VBA Get File Extension - From Path - using Excel macro
Extract File Extension from Path A file extension is the text part of a file name after the last Dot '.' . This extension name is usually used by the operating ...
2019-07-14
Get Current Date in Vba
Display Today's Date & Time in VBA Function used to displaz the current date / time is Vba.Now() This function will return the date & time in this default forma...
2019-07-15
List all windows UserNames & Domain in VBA
List all User Accounts in Windows using VBA In vba use this code to get windows user account names & their domain names. Copy paste this code into your Excel vb...
2019-07-16
Hyperlinks Index - Get all links with address, cell - Whole Workbook
Get list of all Hyperlinks in Excel file This macro produces a hyperlink index sheet. To get list of hyperlinks in each worksheet, the Vba code in this page fol...
2019-07-17
Excel VBA Hyperlink Follow - URL within Macro
How to Click Hyperlink in Excel with VBA Macro? There are 2 methods available to click a hyperlink in Excel. Both the methods do open the URL in the default bro...
2019-07-17
Excel VBA Count #N/A Errors
How to count number of #N/A error in Excel? Number of occurrence of #N/A error in a column can be found by using the formula: Countif(<column>,"#N/A") Consider,...
2019-07-27
How to comment - Block of multiple lines of code - in Vba?
Comment Block & Uncomment Block In VBA to comment a multiple lines of code with single step: There is no keyboard short available commenting. But VBA editor has...
2019-12-04
Excel VBA Dictionary Datatype - Create & Add Keys, Items
Excel VBA Scripting.Dictionary "Dictionary" is a datatype similar to an array, but in addition it can hold a group of variable or objects. Another available dat...
2019-11-12
Merge Multiple Excel Files to One - Selected Sheets
How to Combine Sheets from Multiple Excel to One? This flexible Excel app in this page will merge Worksheets from multiple Excel files to one file. The User get...
2019-11-22
VBA Wait Time - Pause Code Execution for Few Seconds
How to Make VBA to Wait for Few Seconds? Sometimes You have to make code execution to halt (vba wait time) for few minutes. This happens when VBA code has depen...
2019-11-28
VBA - Find My Documents, Desktop & System Folder Path
VBA Code to Find My Documents Folder Path This code will get the folder path directly pointing to the 'Documents" folder. Using this code, the documents folder ...
2019-12-07
Excel VBA - Loop thru all Keys & Items in Dictionary
Dictionary Object - Accessing all Keys & Items In this article, You can get code to access a Dictionary object key & item in a loop. There are 5 different metho...
2020-01-01
VBA get Path to Default Temporary folder
VBA - Find Temporary Folder Path To save any intermediate data files, instead of creating a folder, You can use system default temporary folders. This way, ther...
2019-12-09
Find Last Day of Month - Excel Formula & VBA
How to get Last day of Month? Excel has many option to find this End of Month. But in this page, We have given only the direct method. In Excel this formula can...
2019-12-11
How to Unzip file using VBA - Excel Macro?
Extract Zip - Unzip files with VBA To extract Zip file content, You can use windows default "Compressed (Zipped) Folder" application. There is no inbuilt object...
2019-12-23
Excel to XML Converter - Vba Code - Microsoft Dom
Get VBA Code to Convert Excel to Xml Vba code in this page reads table data by each row and adds it to Xml dom element. Once all the cell values are added, it i...
2020-01-01
Excel Vba Save a Copy of Workbook with TimeStamp
Create Excel file copy with Date & Timestamp in Vba In Vba we can access files & create new files. While doing such file operations, You may have to save a data...
2020-01-03
[Excel Shortcut] - Copy Only Visible Cells - Autofilter - Windows/Mac
Select & Copy Only Visible Cells in Excel In Excel, a row or column may be hidden when we use auto-filter option or manually hide them. Add an auto-filter over ...
2020-01-21
Excel VBA change selection in Dropdown
[VBA] Change Selection - Update Drop Down List in Excel This does not require any special code. It can be done just by changing the value in the particular cell...
2020-01-22
[IPL2020] Delhi Capitals Team – DC Squad, Match Schedule
Delhi capitals match schedule IPL 2020 Date Time Day Team1 Team2 Venue 30-Mar 8 PM Mon DC KXIP Delhi 3-Apr 8 PM Fri KKR DC Kolkata 5-Apr 8 PM Sun RR DC Guwahati...
2020-01-22
[IPL2020] Kings XI Punjab Team – KXIP Squad, Match Schedule
Kings XI Punjab Team Squad Date Time Day Team1 Team2 Venue 30-Mar 8 PM Mon DC KXIP Delhi 4-Apr 8 PM Sat KXIP SRH Punjab 8-Apr 8 PM Wed KXIP MI Punjab 11-Apr 8 P...
2020-01-22
[IPL2020] Kolkata Knight Riders Team – KKR Team Squad, Match Schedule
Kolkata Knight Riders Schedule Date Time Day Team1 Team2 Venue 31-Mar 8 PM Tue RCB KKR Bengaluru 3-Apr 8 PM Fri KKR DC Kolkata 6-Apr 8 PM Mon KKR CSK Kolkata 9-...
2020-01-22
[IPL2020] Mumbai Indians Team – MI Team Squad, Match Schedule
Mumbai Indians Team Schedule Date Time Day Team1 Team2 Venue 29-Mar 8 PM Sun CSK MI Mumbai 1-Apr 8 PM Wed SRH MI Hyderabad 5-Apr 4 PM Sun MI RCB Mumbai 8-Apr 8 ...
2020-01-22
[IPL2020] Rajasthan Royals Team – RRT Squad, Match Schedule
Rajasthan Royals schedule IPL 2020 Date Time Day Team1 Team2 Venue 2-Apr 8 PM Thu CSK RR Chennai 5-Apr 8 PM Sun RR DC Guwahati 9-Apr 8 PM Thu RR KKR Guwahati 12...
2020-01-22
[IPL2020] Royal Challengers Bangalore Team – RCB Squad, Match Schedule
Royal Challengers Bangalore schedule IPL 2020 Date Time Day Team1 Team2 Venue 31-Mar 8 PM Tue RCB KKR Bengaluru 5-Apr 4 PM Sun MI RCB Mumbai 7-Apr 8 PM Tue RCB ...
2020-02-15
2 Methods To - Remove #N/A Error in Excel - Vlookup
1. How to Remove #N/A error in Excel Formula & Vlookup NA Errors? To remove #N/A error, first You should find a way to detect it within the Excel formula. Unfor...
2020-01-30
VBA Copy File to Folder
Excel VBA Macro to Copy File This page explains about 2 options to do file copy using Vba. CopyFile option from FileSystemObject VBA.Filecopy The first one has ...
2020-02-01
VBA Msgbox with Yes No Cancel Options
User Input Msgbox with Yes No Cancel Some time the VBA code has to get approval from user with Yes/No/Cancel optop. Here is the simple code snippet that get the...
2020-02-11
20% Discount Offer link for Fiverr - Hire Experts at affordable Prices
Fiverr - Microjobs Posting Platform If you are looking to hire quality expert to get your job done, Fiverr is right choice. Either you can post Job details with...
2020-02-12
[VBA] How to Convert Word Document to PDF?
This page explains how to save a word document to PDF using: VBA Code PDF Converter Manually Save Word as PDF Both the methods are simple & straight forward. Le...
2020-02-14
Add Excel VBA Drop Down Data Validation List
How to add Data validation drop down list in Excel VBA? Two different methods to create drop down list are explained here - but all are related to validation li...
2020-02-21
[VBA] Read Values in Data Validation Drop Down List
[VBA] Read Drop Down List Values Add a data validation drop down list as explained in this page . Skip this step if there is already a validation created in the...
2020-02-21
Remove Drop Down data validation list from Excel & VBA
How to Remove DropDown box in Excel & VBA? If you know the cell address that you are going to delete, then it is easy. But there are times, where we might want ...
2020-05-02
Hide Unhide Worksheet Tabs in Excel
How to hide/Unhide Sheet Tabs in Excel? By default Excel displays the tabs at left hand side bottom. Using this Users can navigate to any worksheet present in t...
2020-05-02
VBA Message Box Set No as Default Button
How to Set No or Cancel as default Msgbox button? In Msgbox with YesNo or OkCancel buttons, the first button will be set as default button. i.e., once the messa...
2020-06-12
Adding A ToolTip To Any Cell In Excel
When we make a form for others to fill out it is helpful to have some tips to let them know what the cell represent so that they fill out the correct details in...
2020-06-18
Convert Html To Text In Excel
VBA code to convert html to plain text, this helps us to make the html code readable by stripping all the html tags from the html code and printing/rendering th...
2020-07-05
Excel formula to generate random strings.
Random texts are a great, they can be used as the filler texts where you want to show representational text. Or we can generate random text to use as password g...
2020-07-11
Intersect method (Excel)
The Intersect method is used to Returns a Range object that represents the rectangular intersection of two or more ranges. If one or more ranges from a differen...
2020-07-13
Excel TEXTJOIN Function
The TEXTJOIN function combines the text from multiple ranges and/or strings, and includes a delimiter you specify between each text value that will be combined....
2020-08-18
LinkedList in Java
Similar to Arrays in java Linked List is also a Linear data structure. In Linked List unlike arrays elements are not stored in a contiguous locations and they a...
2020-08-19
LET( ) Function in Excel
What is a LET function in Excel? The LET function in excel is used to assign the name of the calculations of the result. This allows storing of intermediate res...
2020-08-22
Queues Interface in Java
Queue Interface: The Queue Interface in Java Collections provide functionality as a Queue in the real-life, it extends the collections interface. It represents ...
2020-09-21
Database Management System
What is DBMS? DBMS stands for Database Management System which is a software used to manage databases. For Example, MySQL, Oracle, etc. are some of the popular ...
2020-09-28
IPL 2020 Points Table PDF - Winners List
IPL 2021 Points table Note: Dream 11 - IPL 13 2020 Points Table IPL13 is proving to be tougher than any other season. New teams are coming up at the top of the ...
2020-10-03
Dream11 IPL 2020 - Points Table - Team Positions
DIPL2020 Points Table - Season 13 - Dubai Let's see how the points table stands now. Pos Team Pld Won Lost Tied N/R Net RR Pts Q Mumbai Indians MI 14 9 5 0 0 1....
2020-10-12
Dynamic Host Configuration Protocol
Introduction The Dynamic Host Configuration Protocol is also known as DHCP , It is a network management protocol used on Internet Protocol(IP) , wherein Dynamic...
2020-10-30
SUM and Average of Top N Values in Excel
In today's world, the data sets we have is huge and we can have so many criteria to be followed on the data For Example: Sum Average etc. Let us say we have N p...
2020-12-20
Power BI - DAX
What is DAX? DAX stands for D ata A nalysis e X pressions and is the language behind Power BI. DAX is a formula expression language used in Analysis Services, P...
2021-07-04
Get Sheet Object Caption and Codename
Worksheet Name & CodeName In Excel, the worksheets will have two names. One is like its caption & other is object Name. In the VB editor, in project explorer (C...
2021-08-21
How to open VBA in Excel - Macro code editor?
How to open VBA code or Macro code in an Excel file? You will be able to open VBA (Visual Basic for Applications) code written within a Excel file using any of ...
2021-09-25
Export VCF to Excel - Converter Online - Using Google Account
Export VCF to Excel using Google Account To convert Export VCF to Excel use your Google account and follow these simple steps. This will guide you to import the...
2021-10-08
Run Macro from Another Workbook - Excel VBA
How to run a macro from another workbook? It is possible to run a macro present in a workbook to be execued from another workbook. To do this, we need the follo...
2021-10-10
How to run VBA Macro Daily without opening Excel file autiomtically?
Schedule Excel VBA Macro to Run Daily Automatic VBA Macro is used to automate lot of repeated tasks in Ms Office applications like Excel, Access, Outlook, Power...
2021-11-04
How to Add Leading Zeroes in Excel - for Numbers?
A. Insert Numbers with Leading Zeroes in Excel To add leading zeroes in Excel to a number, use one of these methods. But before using one of these methods, you ...
2021-11-21
VBA - Find number of Dimensions in an Array
Find how many dimensions an Array has? We use array to store multiple values under same variable name. This array can be a simple one dimensional array or multi...
2021-12-05
VBA Convert Excel range to JPG Image
How to convert a range of Cell in Excel to Image file? The following VBA code is a User Defined Function (UDF) that can save a group of continuous cells as a JP...
2021-12-05
VBA To Find Last Row or Column in a Excel Wroksheet.
Finding last row or column in a worksheet using VBA Do you want to find out the last nonempty cell in both vertical (row) and horizontal (column) direction. You...
2021-12-14
Convert a XML file into a Excel Sheet
VBA Loads a XML file into a Excel Sheet An XML file is like a simple text file but structured in a predefined format using tags. Sometimes you need to view an X...
2021-12-14
Excel VBA Code to Checks if File Exists in Path
Finding an existing file & its path using Excel VBA When writing Excel VBA code that works with external files like XML or JSON, it is important that you have c...
2022-04-08
VBA Userform - Escape key to Close - Unload form
Make VBA Userform to Close with Escape Key Usually developers add a command button to close or exit a userform. Sometimes, if the end user is going to close the...
2022-04-24
How to create drop down list in Google sheets?
Add Google Sheets Drop Down List Here are the steps to create a drop down list in Google sheets. We will be using the data validation built in option to do this...
2022-04-24
How to remove Drop down list in Excel?
Delete a Drop down data valition list in Excel A drop down list in Excel also has another term "Data valiation list". These drop down lists usually has a list o...
2022-05-02
Outlook VBA - Sort Emails by Date - in a Folder
VBA Code to Sort Outlook Emails by Date In Outlook app, when you are viewing the mails in any folder, You have option to Sort them based on Received date/time, ...