欢迎来到天天文库
浏览记录
ID:34753460
大小:72.68 KB
页数:6页
时间:2019-03-10
《在excelvba中调用excel自带函数》由会员上传分享,免费在线阅读,更多相关内容在工程资料-天天文库。
1、在ExcelVBA中调用Excel自带函数-ExcelVBA学习 2010-03-2919:45:25
2、 分类: computer
3、字号 订阅最近在写一个VBA的程序,想自己生成一些报表.便遇到了在VBA中无法使用SUM函数.解决的方法如下:前段时间为公司实验室编制测试数据库,其中遇到一个问题,怎样在VBA中使用Excel自带的一些函数呢?如min,max,average等等。本以为能在Excel表格中直接使用的函数也能直接移植到VBA中,结果发现根本行不通,程序报错。后来通过多方查询发现,虽然不能直接引用,但是我们可以曲线救国,excel中表格可以用max函数,在VBA中也可
4、以用,只需通过WorksheetFunction对象就可以引用,后面加函数名称,然后加range来引用单元格。举个例子:Application.WorksheetFunction.Max(range("A1:C5"))下面就是能在VBA中使用excel自带函数:A__AcosAcoshAndAsinAsinhAtan2AtanhAveDevAverageB__BetaDistBetaInvBinomDistC__CeilingChiDistChiInvChiTestChooseCleanCombinConfidenceCorrelCoshCountCountACountBlankC
5、ountIfCovarCritBinomD__DAverageDays360DbDCountDCountADdbDegreesDevSqDGetDMaxDMinDollarDProductDStDevDStDevPDSumDVarDVarPE__EvenExponDistF__FactFDistFindFindBFInvFisherFisherInvFixedFloorForecastFrequencyFTestFvG__GammaDistGammaInvGammaLnGeoMeanGrowthH__HarMeanHLookupHypGeomDistI__6、ptIpmtIrrIsErrIsErrorIsLogicalIsNAIsNonTextIsNumberIspmtIsTextJ__K__KurtL__LargeLinEstLnLogLog10LogEstLogInvLogNormDistLookupM__MatchMaxMDetermMedianMinMInverseMIrrMMultModeN__NegBinomDistNormDistNormInvNormSDistNormSInvNPerNpvO__OddOrP__PearsonPercentilePercentRankPermutPhoneticPiPmtPoissonPo7、werPpmtProbProductProperPvQ__QuartileR__RadiansRankRateReplaceReplaceBReptRomanRoundRoundDownRoundUpRSqRTDS__SearchSearchBSinhSkewSlnSlopeSmallStandardizeStDevStDevPStEyxSubstituteSubtotalSumSumIfSumProductSumSqSumX2MY2SumX2PY2SumXMY2SydT__TanhTDistTextTInvTransposeTrendTrimTrimMeanTTestU__USD8、ollarV__VarVarPVdbVLookupW__WeekdayWeibullX__Y__Z__ZTest
6、ptIpmtIrrIsErrIsErrorIsLogicalIsNAIsNonTextIsNumberIspmtIsTextJ__K__KurtL__LargeLinEstLnLogLog10LogEstLogInvLogNormDistLookupM__MatchMaxMDetermMedianMinMInverseMIrrMMultModeN__NegBinomDistNormDistNormInvNormSDistNormSInvNPerNpvO__OddOrP__PearsonPercentilePercentRankPermutPhoneticPiPmtPoissonPo
7、werPpmtProbProductProperPvQ__QuartileR__RadiansRankRateReplaceReplaceBReptRomanRoundRoundDownRoundUpRSqRTDS__SearchSearchBSinhSkewSlnSlopeSmallStandardizeStDevStDevPStEyxSubstituteSubtotalSumSumIfSumProductSumSqSumX2MY2SumX2PY2SumXMY2SydT__TanhTDistTextTInvTransposeTrendTrimTrimMeanTTestU__USD
8、ollarV__VarVarPVdbVLookupW__WeekdayWeibullX__Y__Z__ZTest
此文档下载收益归作者所有