Getting last blank cell

If you want to know the last blank cell of your column, ignoring the blank cells within that column, you can use below code.  This code will store th...

Change the selection with one or more areas to Values using VBA in Microsoft Excel

In this chapter, we are going to learn how to change the selection with one or more areas to values using VBA in Microsoft Excel.   Let’s t...

Change a Column or Columns to values using VBA in Microsoft Excel

In this chapter you will learn, how to change all the cells in the active sheet to values, using VBA in Microsoft Excel. Let’s take an example and ...

Change a Row or Rows to values to values using VBA in Microsoft Excel

We write the VBA coding to allow the Excel to do the repetitive work automatically within less time. In this chapter you will learn about how to chang...

Change cells in the Activecell rowrange to values using VBA in Microsoft Excel

In this chapter you will learn how to change cells in the active cell row range to values using VBA in Microsoft Excel. Let’s take an example and u...

Change range with more then Area to values using VBA in Microsoft Excel

In this article you will learn about how to change range with more than area to values using VBA in Microsoft Excel. Let’s take an example and unde...

Change the formula in the cells in a range to values using VBA in Microsoft Excel

In this article, we will learn how to change the formula in the cells in a range to values using VBA in Microsoft Excel. Raw data for this exam...

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.