Method Archives - Xelplus - Leila Gharani

How to Use Excel VBA GetOpenFileName to Browse and Select File

Leila Gharani — Thu, 26 Sep 2019 09:00:00 +0000

You can use Excel VBA GetOpenFileName method to copy data from another Excel file by browsing for and selecting the file from the Open File Dialog Box.

The post How to Use Excel VBA GetOpenFileName to Browse and Select File appeared first on Xelplus - Leila Gharani.

How to Sum Cells by Color in Excel

Leila Gharani — Thu, 18 Jul 2019 09:00:00 +0000

Use this Excel formula to sum cell values based on cell color. The formula is an Excel VBA function. Copy and paste the code in your files so you can sum values based on background cell color.

The post How to Sum Cells by Color in Excel appeared first on Xelplus - Leila Gharani.

Excel VBA FIND Function

Leila Gharani — Thu, 12 Jul 2018 07:55:00 +0000

Find out how to use the FIND function in Excel VBA. This can be more effective than looping through large data ranges. VBA also results in error if the value is not found. How can you overcome this error? Find out in the article.

The post Excel VBA FIND Function appeared first on Xelplus - Leila Gharani.

VBA Copy Paste

Leila Gharani — Thu, 19 Apr 2018 17:31:00 +0000

This tutorial shows you how you can copy and paste with VBA. You will learn the copy and pastespecial methods, as well as resize and offset properties in order to fully control what you copy and paste from ranges.

The post VBA Copy Paste appeared first on Xelplus - Leila Gharani.

VBA Object Properties & Methods

Leila Gharani — Thu, 05 Apr 2018 11:56:00 +0000

Understand Object Properties and Methods in VBA. It is a key skill if you’d like to write your own Excel VBA code from scratch or update the VBA code you find on forums.

The post VBA Object Properties & Methods appeared first on Xelplus - Leila Gharani.