My Blog

.Find and .FindNext

The most under utilized feature of Excel when it comes to finding data is .Find and .FindNext. Most of us use loops in case we want to find something in Excel. For Example, Let’s say Our data is in sheet1 from Cell A1 to A65000 and the data is like this A1 → 1 A2 → 2...

Text To Columns

There are many occasions where we need to open a text file in Excel and then arrange them in separate columns. If we directly open the file in Excel then we notice that everything is filled in Col A. In such a scenario what  can we do? Excel has an inbuilt feature...

Find and Replace

Find and Replace in Excel gives us very limited options to work with. For example, if you look at the image below, you will realize that you can only replace text in Formulas. You can use this option to replace text in Values as well but not Comments. Now what if you...

Interacting with Comments

In continuation from here... We already covered here how to create the form, set references and place the required buttons. In this post we will cover the following: Insert Comment Edit Comment Delete Comment Show/Hide Comment Format Comment Insert Image in Comment...

Merging/Unmerging Cells

In continuation from here... We already covered here how to create the form, set references and place the required buttons. Here is an example for merging cells A1 to E1. Imports Excel = Microsoft.Office.Interop.Excel Public Class Form1...

Copying and Pasting Range

In continuation from here... We already covered here how to create the form, set references and place the required buttons. There are many times when you want to copy a range from one area to another or from one worksheet to another. I would be covering these 3...

Adding/Deleting Sheets to the Excel File

In continuation from here... We already covered here how to create the form, set references and place the required buttons. Adding and Deleting sheets in Excel is very simple. Consider this code. I am also using the DoesSheetExist Function from here to demonstrate the...

Checking if a Sheet Exists

In continuation from here... Sometimes you need to know if a particular sheet is there in an Excel workbook. I am showing you two ways to check that. The first way is to directly check for the existence of that sheet and the second way is to create a function so that...