Find and Select the First Blank Cell in a Column VBA

Sometimes, You may need to find and select the first blank cell or last blank cell in a column, these macros can help you. Find and Select the First Blank Cell in Column A Sub Macro1() Dim ws As Worksheet Set ws = ActiveSheet For Each cell In ws.Columns(1).Cells If…

Select a Range In Excel VBA

One of the basic things you need to do in Excel VBA is to select a specific range to do something with it. This article will show you how to use Range, Cells, Offset and Resize to select a range in Excel VBA. Select all the cells of a worksheet…