vba in excel: calculate Mode# Windows - 看得见风景的窗口
s*r
1 楼
VBA in excel, I use
theMode = Application.WorksheetFunction.Mode(theData)
theData is data range.
sometime, the data dose not have a mode, so my VBA program just halt there,
is there a way to detect if theData have mode or not, and if have mode,
execute
theMode = Application.WorksheetFunction.Mode(theData)? thanks.
theMode = Application.WorksheetFunction.Mode(theData)
theData is data range.
sometime, the data dose not have a mode, so my VBA program just halt there,
is there a way to detect if theData have mode or not, and if have mode,
execute
theMode = Application.WorksheetFunction.Mode(theData)? thanks.