L Lena Apr 7, 2004 #1 How can i get the value of the rightmost/leftmost cell from a specific column if the value's not blank ?? Thanks 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 Apr 7, 2004 #2 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)
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)
G Guest Apr 7, 2004 #3 Not sure I understand What classifies a cell as being the rightmost or leftmost from a single column? -Brad
Not sure I understand What classifies a cell as being the rightmost or leftmost from a single column? -Brad
T Tom Ogilvy Apr 7, 2004 #4 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?
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?
