non blank cell in a column

H

Harvey Waxman

Is there some way to capture the value of the last non-blank cell in a range?

Thanks
 
B

Bernard Rey

Harvey Waxman wrote :
Is there some way to capture the value of the last non-blank cell in a range?
Click to expand...

I guess it's within a Macro you're trying to get this. Her's my suuggestion:

Range("A1") = Range("A65536").End(xlUp).Value

This will browse the col A, starting from the very bottom, up to the first
non-blank cell and put it's value in Cell A1.
 
H

Harvey Waxman

Harvey Waxman wrote :


I guess it's within a Macro you're trying to get this. Her's my suuggestion:

Range("A1") = Range("A65536").End(xlUp).Value

This will browse the col A, starting from the very bottom, up to the first
non-blank cell and put it's value in Cell A1.
Click to expand...


Merci very much
 
Top