Finding first (end of range) empty cell
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
"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
|