Contents of Rightmost Cell

Hi everyone,

I'm looking to get the contents for the rightmost cell of a range selection.

The contents would be the input for standard excel formulas.

I've tried a mix of standard formulas but they only seem to work for pure text or numbers. The range I have consists of both text and numbers. (Just for reference the link I used to construct the formula: http://answers.microsoft.com/en-us/o...c-68b599b31bf5)

Can someone provide a vba formula for this purpose? The input to this vba formula would be the range and the output the contents of the rightmost cell.

Thanks in advance,
Andrew

Hi the following gives a #Value error:

Function RightMostCell()
myValue = myRange(1, myRange.Columns.Count).Value2
RightMostCell = myValue
End Function


I've used it in the workbook as:
"=RightMostCell(INDIRECT(JU9))"

Indirect references the range where the rightmost cell is wanted. The range is a row eg. "EA9:FA9"

Please assist to advise? Thanks!

Hi sorry think I need to clarify. I'm looking to get the rightmost cell with data and to ignore blanks. The range includes cells that contain either text, numbers or blanks.

Hi everyone, any one have any ideas? Still looking for a solution to this. Thanks!