Leftmost and Rightmost Cell

L

Lena

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

Thanks
Lena
 
B

Bob Phillips

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)
 
B

Brad Vontur

Not sure I understand

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

-Brad
 
T

Tom Ogilvy

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?
 
Top