Hi All

I have a c# program I'm working on it opens an excell file and displayes the results in a DataGrid at the moment I have it selecting the cell with the code below.

//Set excel sheet range
exr.SheetRange = "A1:C5";

What I'm trying to make it do is select the data from cells M3, M4, E5, G5, H5, R5 then go to cell G7 and read till the last empty cell to the right of G7 then read down from G7 to the last empty cell.

Any one know how to do this?

Matt have you managed to work this one out?