Vb how statistics Excel to specify a column the number of rows, not the whole area of using lines, are the use of a single column the number of rows, because of the use of different column is not the same as the number of rows, there is no quick way, give advice or comments please,

CodePudding user response:

Use the number of lines is what mean? Refers to the cell is not empty?

CodePudding user response:

Yes! Cell cannot be null, or Spaces!

CodePudding user response:

 'Microsoft Excel/VBA code: 

'return to work table Shee1 column A how many "cell" has A value of "value" : 
'note: "the numerical in text format said" cell is not in statistical scope of 
WorksheetFunction. Count (Sheet1. Range (A: A)) 

'return to work table Shee1 column A how many "cell" value is not empty (includes text, numerical) 
WorksheetFunction. CountA (Sheet1. Range (A: A)) 

CodePudding user response:

The "Excel." in the code can not write,

CodePudding user response:

reference Chen8013 reply: 3/f

 'M $Excel/VBA code: 

'return to work table Shee1 column A how many "cell" has A value of "value" : 
'note: "the numerical in text format said" cell is not in statistical scope of 
WorksheetFunction. Count (Sheet1. Range (A: A)) 

'return to work table Shee1 column A how many "cell" value is not empty (includes text, numerical) 
WorksheetFunction. CountA (Sheet1. Range (A: A))