Provide value of the last populated cell in row

[AlgerianHippo]

Is there a formula or way that you would look at all the cells to the left of it, and return the rightmost cell?

For example,

ABCDE----------FORMULA (Returns E)
ABC-------------FORMULA (Returns C)
ABCDEFG-------FORMULA (Returns G)

 

[AlanY]

try

=LOOKUP(1E+100,1:1,1:1)

 

[MoshiM]

Is there a formula or way that you would look at all the cells to the left of it, and return the rightmost cell?

For example,

ABCDE----------FORMULA (Returns E)
ABC-------------FORMULA (Returns C)
ABCDEFG-------FORMULA (Returns G)

Sub Count_To_Last_Column_In_Row()
Dim I as long,H as long
'Variable "I" is the row number that you want to count
'You can loop through the number of rows and set I to the current row with a "for loop"

'Will not work if there are empty cells in-between the number of cells you want to count

H=Activesheet.Range("A"&I).End(xlToright).column


End Sub

All that would be left for you to do is to write that value to the cell you want or use a msgbox