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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Leftmost/Rightmost Cell 2
How to find .Name of leftmost worksheet tab 2
Search Target <= in Col. "B" to return Date in Col. "A" 0
formula to delete first n chars 3
Find column number of last used cell in a row 5
Table exceeds width of page, unable to correct it ! 1
Sub assistance 25
Last cell with constant in a sheet 4

Top