How to count total number of rows in a excel column

[newcoder1010]

Set ExcelObj = createobject("excel.application")
ExcelObj.Visible = true
Set ExcelConfigFile = ExcelObj.Workbooks.Open (Path)
Set Sheet = ExcelConfigFile.Worksheets("Scripts")
TotalRow = Sheet.UsedRange.Rows.Count

Hello,

So far, I get total number of row of the sheet. I have a column called "key". How can I count total number of rows in the key column?

Thanks.

[justsomeguy]

Is that different from the rows in the sheet?  Look at the documentation for that object you're using, and see what properties and methods are available.  I assume instead of the UsedRange property you'll want to use a different one, maybe even define your own range.