How to check for next empty cell in list

  • Thread starter Thread starter DonW
  • Start date Start date
D

DonW

BlankI'm fairly new to vba....if someone could assist please.......

What is the best code for checking for the next empty cell in a list?

A
1 a
2 b
3 c
4 d
5 <-- checking for this empty cell
6
7

Thanks for any help........
Don
 
BlankDon,

This should do it

Cells(Rows.Count,"A").End(xlUp).Offset(1,0).Select

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

I'm fairly new to vba....if someone could assist please.......

What is the best code for checking for the next empty cell in a list?

A
1 a
2 b
3 c
4 d
5 <-- checking for this empty cell
6
7

Thanks for any help........
Don
 
BlankCells(1, 1).End(xlDown).Offset(1, 0).Select

I'm fairly new to vba....if someone could assist please.......

What is the best code for checking for the next empty cell in a list?

A
1 a
2 b
3 c
4 d
5 <-- checking for this empty cell
6
7

Thanks for any help........
Don
 
BlankThanks Bob
Don,

This should do it

Cells(Rows.Count,"A").End(xlUp).Offset(1,0).Select

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

I'm fairly new to vba....if someone could assist please.......

What is the best code for checking for the next empty cell in a list?

A
1 a
2 b
3 c
4 d
5 <-- checking for this empty cell
6
7

Thanks for any help........
Don
 
Back
Top