View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
DonW DonW is offline
external usenet poster
 
Posts: 5
Default How to check for next empty cell in list

BlankThanks Bob
"Bob Phillips" wrote in message ...
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)

"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