Ask a new question

Use VBA Excel to select 8 non-specific blank cells in a column

Hi

I'm trying to find a way to use VBA in excel to select a column of 8 blank cells starting with (and including) a changing active cell.

To expand a little, the idea is to find the first blank cell in a column, select 8 cells down including that cell and paste the same thing into all the cells.

I'm hoping to make this part of a ' for each' loop

I'm still learning VBA so any help will be useful

Thank you,

Dan

hi

if any one else is searching for this I have found one way

Dim first_cell As String

Dim last_Cell As String

If IsEmpty(ActiveCell) Then

first_cell = ActiveCell.Address 'finds address of first cell eg. A1

last_Cell = ActiveCell.Offset(7, 0).Address 'finds address of last cell eg. A8

Range(first_cell, last_Cell).Select

End If

I don't know if there is a better way, but this seems to work

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

 
 

Question Info

Last updated March 30, 2025 Views 53 Applies to: