This project has moved and is read-only. For the latest updates, please go here.

Find a range of an existing worksheet

Nov 22, 2011 at 11:14 PM

Sorry if this is obvious - I have searched but yet to find a solution...

Other than iterating over the rows and columns to find empty cells, how do you find an existing range of data in worksheet?

Nov 28, 2011 at 6:30 AM

Not sure what you mean. Use the Worksheet.Dimension property to find the worksheet range or use foreach on the Cells property to return cells set cells.

Dec 8, 2011 at 9:12 PM

Nice. Should have been obvious to me - thanks for the response. The Dimension property is what I was looking for...