09-23-2024
08:04 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report
09-23-2024
08:04 AM
Hi guys. There is actually a property for this on Excel's side. Check out the Worksheet.UsedRange property, which returns a Range object. Once you have that, you can use the Range.Rows property or its Range.Columns property (which both also return Range object) and use the Count property to get the Index of the last one being used. However, I believe this assumes that you have something in your first row and first column. I have used that little trick for years and it has worked OK for me.
Wesley Crihfield
(Not an Autodesk Employee)