Finding first (end of range) empty cell
 

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

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

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

Finding first (end of range) empty cell
 

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

Regards,

Vasant.

"Don Guillett" wrote in message
...
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

Finding first (end of range) empty cell
 

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