View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Rob van Gelder[_4_] Rob van Gelder[_4_] is offline
external usenet poster
 
Posts: 1,236
Default How to check for next empty cell in list

BlankCells(1, 1).End(xlDown).Offset(1, 0).Select

"DonW" wrote in message
...
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