Announcements
Attention for Customers without Multi-Factor Authentication or Single Sign-On - OTP Verification rolls out April 2025. Read all about it here.
WCrihfield
in reply to: OPthorsager

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

EESignature

(Not an Autodesk Employee)