If you can select a cell in each row then:

Selection.End(xlToLeft).value

or (xlToRight)

should get you started


"Andrew" wrote:

Ladies & Gents,

I'm using a spreadsheet which has many rows of information, with multiple
start & finishing columns. Can anyone help me with a function that can
return the first & last values of each row?

I forgot to mention that I'm using Excel 97 to create the spreadsheet
mentioned.


TIA

Andrew Sbrana