I have several excel workbooks from which I need to read data. The sheet in each workbook is named "program"; however, the 1st row of data is different w/in each sheet. I can name the range where the data resides. I need code to find the first row of the range so I can set that as my starting value for the loop to read each row. I also need a way to identify my last row.