BLOG
VBA TRICKS

VBA Code to Filter Data in Excel

Here is an easy reference code which filters data in the sheet. In the code, we have filtered the data in three steps. Step 1: Remove existing filter from the sheet (if any). This code ensures if there is already a filter applied then the same is removed first Step …

Read More
FREE VBA UTILITIES

VBA Tool to Merge Excel Files from a Folder

From last few months, we have been receiving frequent requests from users for a VBA tool which can consolidate Excel files from a folder. So here we come with one more free VBA tool from ExcelSirJi team. With this Excel Consolidator tool, you will be able to consolidate data from …

Read More
VBA TRICKS

VBA Code to Change Cell Color

Excel supports more than 16 million colors in a cell; hence you should know how to set the exact color in a cell. To do this, you can use RGB (Red, Green, Blue) function in VBA to set the color of a cell. The function requires 3 numbers from 0 …

Read More
RGB Code
VBA TRICKS

How to get RGB Codes of a Color

Excel supports more than 16 million colors in a cell; hence you should know how to set the exact color in a cell. To do this through VBA, you can use RGB (Red, Green, Blue) function to set the color of a cell. The function requires 3 numbers from 0 …

Read More
VBA TRICKS

VBA Code to Convert MM.DD.YYYY Format to DD-MMM-YYYY

In different parts of the world, there are different languages spoken and written. With this, a VBA programmer also faces language related issues while writing a VBA program. Here is a common date related problem solved which converts a date written in MM.DD.YYYY format into Excel standard date. ‘This function …

Read More
EXCEL TRICKS

Few Simple Excel Tips – Excel Learner Should Know

1. Change Direction When You Press Enter Whenever you press enter, you must be thinking why my cell selection shifts down. Why it can’t go UP, Down, Left. Surprised This is very simple. Do you want to change the direction? So let’s do it Click on below highlighted button “File”: …

Read More
Excel Tricks
EXCEL TRICKS

Impress your Clients by Hiding these Simple Features

While preparing many projects, my clients always want me to make professional, good looking dashboards. So I hide few things like Gridlines, Column & Row headings and Formula Bar. This can give WOW experience to your bosses, clients because after hiding these features, you excel sheet looks like a software …

Read More
EXCEL TRICKS

Lock Cells to avoid editing, Hide Formulas

Sometimes you create amazing projects, dashboards however people can make mistakes and edit the calculations, formats what you have made. Still you can protect the sheets, workbooks and prevent users to make any editing via “Protect Workbook” Option However you need an additional feature along with the “Protect Sheet” to …

Read More
EXCEL TRICKS

Protect Sheets, Share Workbook, Protect Workbook

Creating beautiful and professional dashboards, projects always lead you to success however there are places when you wanted to protect your dashboards, sheets, cells to prevent users to make unnecessary editing because it can change calculations, sheets and sometimes, finish the essence of the project So here we are talking …

Read More
FREE VBA UTILITIES
3

Excel VBA Tool to Get File Properties

Here is one more interesting VBA tool from ExcelSirJi team. File Properties Tool is an Excel VBA tool which gets the following properties of the file. File Name Date Created Date Last Accessed Date Last Modified Size (MB) Type  You just need to browse the folder where your files are …

Read More
Excel Tricks
EXCEL TRICKS

Hide Excel Sheet/Tab – Complete Guide

When I was creating an excel dashboard, there were multiple sheets which I used for calculation purpose and never wanted anybody to make any changes on it. So I found very awesome feature to hide an excel tab: Though there are multiple ways to hide the excel sheet tab: 1. …

Read More

Facebook
Facebook
YouTube
YouTube
Pinterest
Pinterest
LinkedIn