Last in row

[Svgmassive]

I am trying to get the last column in a row that has data.listed below is the way the data is arrange the counta function only goes to the first blank i need this to be a dynamic name range. thanks

a b c d e f g
10 2 "e"

 

[jbeaucaire]

What do you mean by "get the last column" ? Are you trying to get a formula to tell you that the last column with data in this list is "6"? Column F is the 6th column:

Excel Workbook
	A	B	C	D	E	F	G	H
1	10			2		e
2								6
Sheet3