View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Don Guillett[_4_] Don Guillett[_4_] is offline
external usenet poster
 
Posts: 2,337
Default Finding first (end of range) empty cell

Vasant, Is you system date off?

--
Don Guillett
SalesAid Software

"Vasant Nanavati" <vasantn *AT* aol *DOT* com wrote in message
...
Range("A" & Rows.Count).End(xlUp).Offset(1).Address

--

Vasant

"Alesandro Senerchia" wrote in message
...
Hi,

i'd like to know how would it be possible to find the first empty cell

in
a
colum (after a range of values, ie bottom example), with having a static

row
value (this sheet would have variable numbers of rows). The column

would
be
static.

ex :

In this case id like to know the address A4, reminder, there might be

more
rows or less, depending on the file.

a b c d
1 X X X X
2 X X X X
3 X X X X
4

Thank you for your answer, in advance

Alex