Macro Archives

VBA

Data Consolidation: Allow User to select files on Runtime

April 8, 2019March 1, 2023 PKComments Off

In this article, we will explain to you the Data Consolidation from multiple Excel files using Application.GetOpenFileName in VBA. You can easily allow the user to select multiple excel files

Charts and Visualization VBA

Resize and Relocate the Chart using Excel Range

March 23, 2019March 23, 2019 PKComments Off

In this article you will learn a trick to resize and relocate a chart using VBA. We have created a shortcut key Shift+Ctrl+R to resize and relocate active chart. You

VBA

VBA: Split Data into Separate Workbooks

July 15, 2018 PK0

In this article you will learn how we can split our data into multiple workbooks. Every workbook will be saved in the given folder path. This macro can be used