解决方法
我想
Excel.WorksheetFunction.CountA不仅可以使用工作表,还可以使用任何Range参数:
Use CountA to count the number of cells that contain data in a range
or array.@H_301_9@A value is any type of information,including error values and empty
text (“”). A value does not include empty cells.@H_301_9@If an argument is an array or reference,only values in that array or reference are used. Empty cells and text values in the array or reference are ignored.@H_301_9@