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
Bookmarks