Selecting a specific empty cell of a column

**mayorofarta** · 04-23-2013, 10:31 AM

I've got a column (B) where my macro stores data. The first cell of this column (B1) should be empty and B2 contains the title. Data are written from B3 to Unknown (depends on number of execution). I d like this macro to check the position of the selected cell and return it to the next empty cell of the column B before it runs. For Example, if data are written to B3:B7 it should select B8 before it is run, in case another cell was selected accidentally or B3 if nothing was written.

**p24leclerc** · 04-23-2013, 11:03 AM

the following code will position Excel to the first empty cell in column B

Please Login or Register  to view this content.

**mayorofarta** · 04-23-2013, 11:12 AM

Is there a way to position Excel to the second empty cell of the column if column B is not selected?

**p24leclerc** · 04-23-2013, 11:17 AM

the code I supplied works no matter which column is selected.
If you want to select second empty cell, change the 1 in the Offset part of the code to 2. The first part of the code is to locate the last NON-EMPTY cell in column B. You make an offset to select the cell you want.