Finding first (end of range) empty cell

[Alesandro Senerchia]

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

 

[David Adamson]

Alex

Try the following to get you started



Sub Find_Address()
'range("a3")=start of the column you want to find the address on
lastcell = Range("a3").End(xlDown).Offset(1, 0).Address '.Select
MsgBox lastcell


End Sub

 

[Don Guillett]

Vasant, Is you system date off?

 

[Vasant Nanavati]

Yep ... second time it's happened this month. Don't know why. Fixed now,
thanks.

Regards,

Vasant.

 

[Vasant Nanavati]

Range("A" & Rows.Count).End(xlUp).Offset(1).Address