newcoder1010 Posted October 25, 2017 Share Posted October 25, 2017 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. Link to comment Share on other sites More sharing options...
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!Register a new account
Already have an account? Sign in here.Sign In Now