Export Excel Range to Image (jpg/png/gif) using Vba? This code ill convert the data in Excel workbook into a jpg image file as how it is displayed on screen. The image format can be jpg, png or gif. We have not tested if this supports other image formats as well, […]
Excel Vba Sort Array – Quick Trick using built in function
January 24, 2020
VBA Array Sort – Using Excel Sort In this page, we have given a Excel vba code snippet that works well for sorting array of 1 dimension. You can also customize & extend this code to work for 2 dimension array as well. We will publish the code for 2D […]
VBA – Create Array from Excel Range – 1 Dimension
January 24, 2020
Excel Macro – Create 1D Array from Vba Array This is one of the easy methods to initialize an array. If you convert data in worksheet directly to vba array, then it will create a 2d array by default. If you would like to convert Excel range to Array of […]
VBA Array Initialize Values – Split string to array
January 24, 2020
How to Initialize an Array in Vba? Different methods to assign values to array are explained here. Starting from basic to few easy methods to initialize array with multiple values are discussed in here. Here are the list of available methods. Direct or a loop method. Using VBA function Array. […]
VBA – Add Items to Array – Dynamic Resize without erasing data
January 24, 2020
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: […]
How to find your VBA Version – V6 or V7?
January 24, 2020
How to find Your VBA Version? The below code will get the VBA version detail using pre-compiler directives. We cannot display the value in thee variables. But it can be used inside the #IF. Then we can print the required values. Here is the code that can fetch VBA version […]
[Outlook VBA] Select Appointments/Meetings Invites in Inbox
January 24, 2020
Appointment/Meeting Invites using VBA In addition to handling Emails, MS Outlook application also handles calendar appointments & meeting invites. All these items are received in your Inbox. We could identify the difference manually by seeing the icon for each item. But to identify the difference in a VBA code, we […]
[Excel Shortcut] – Copy Only Visible Cells – Autofilter – Windows/Mac
January 24, 2020
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 a column or a table & Select a valid value for the filter. This action will hide few rows which […]
Validate Email Address – VBA Code – Excel
January 24, 2020
Verify Email Address Format in VBA Code in this page will verify if a email id is in proper format. This code uses regex pattern matching. To do this, first You need to define a regular expression pattern that will match a valid email id. A email id has a […]
VBA get Path to Default Temporary folder
January 24, 2020
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, there is less coding effort required to manage the new folders. But, to do that, You need to first find the folder path. There may […]
