Thread: Find End of List
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
James Snell James Snell is offline
external usenet poster
  
Posts: 46
Default Find End of List
Range("A1").End(xlDown)


"Joe Schmo" wrote:

How do I find the cell address the end of a list. See list below. How to
find cell A5.

A1 Jim
A2 John
A3 Sally
A4 Sara
A5 Bill


Reply With QuoteReply With Quote