How can i get the value of the rightmost/leftmost cell
from a specific column if the value's not blank ??

Thanks
Lena

Do you mean a specific row. This is for row 2

cells(2,"A").end(xltoright).value

cells(2,columns.count).end(xltoleft).value

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Lena" wrote in message
...
How can i get the value of the rightmost/leftmost cell
from a specific column if the value's not blank ??

Thanks
Lena

Not sure I understand

What classifies a cell as being the rightmost or leftmost from a single column?

-Brad

A specific column only has a centermost cell.

Why not try restating your question. What are you trying do to. Are you
looking for the visible range? Specific row?

--
Regards,
Tom Ogilvy


"Lena" wrote in message
...
How can i get the value of the rightmost/leftmost cell
from a specific column if the value's not blank ??

Thanks
Lena