[已解决]为什么VBA一直报错说average无法调用啊？

Shelvee

如题！。。。。。。。。。。。

最佳答案

月排行榜 / 总排行榜

hwc2ycy

2013-2-27 20:02

(, 下载次数: 159)

上传

点击文件名下载附件

跳转到最佳答案楼层

hwc2ycy

查了下，average是可以调用的。

hwc2ycy

值里是不是有非数值。

hwc2ycy

可用于 Visual Basic 的工作表函数列表

下表列出了所有可用 WorkSheetFunction 对象调用的工作表函数。有关特定函数的详细信息，请参阅 Office 网站上的函数参考主题。

AccrInt

AccrIntM

Acos

Acosh

Aggregate

AmorDegrc

AmorLinc

And

Application

Asc

Asin

Asinh

Atan2

Atanh

AveDev

Average

AverageIf

AverageIfs

BahtText

BesselI

BesselJ

BesselK

BesselY

BetaDist

BetaInv

Bin2Dec

Bin2Hex

Bin2Oct

Binom_Dist

Binom_Inv

BinomDist

Ceiling

Ceiling_Precise

ChiDist

ChiInv

ChiSq_Dist

ChiSq_Dist_RT

ChiSq_Inv

ChiSq_Inv_RT

ChiSq_Test

ChiTest

Choose

Clean

Combin

Complex

Confidence

Confidence_Norm

Confidence_T

Convert

Correl

Cosh

Count

CountA

CountBlank

CountIf

CountIfs

CoupDayBs

CoupDays

CoupDaysNc

CoupNcd

CoupNum

CoupPcd

Covar

Covariance_P

Covariance_S

CritBinom

CumIPmt

CumPrinc

DAverage

Days360

Db

Dbcs

DCount

DCountA

Ddb

Dec2Bin

Dec2Hex

Dec2Oct

Degrees

Delta

DevSq

DGet

Disc

DMax

DMin

Dollar

DollarDe

DollarFr

DProduct

DStDev

DStDevP

DSum

Duration

DVar

DVarP

EDate

Effect

EoMonth

Erf

Erf_Precise

ErfC

Even

Expon_Dist

ExponDist

F_Dist

F_Dist_RT

F_Inv

F_Inv_RT

F_Test

Fact

FactDouble

FDist

Find

FindB

FInv

Fisher

FisherInv

Fixed

Floor

Forecast

Frequency

FTest

Fv

FVSchedule

Gamma_Dist

Gamma_Inv

GammaDist

GammaInv

GammaLn

GammaLn_Precise

Gcd

GeoMean

GeStep

Growth

HarMean

Hex2Bin

Hex2Dec

Hex2Oct

HLookup

HypGeom_Dist

HypGeomDist

IfError

ImAbs

Imaginary

ImArgument

ImConjugate

ImCos

ImDiv

ImExp

ImLn

ImLog10

ImLog2

ImPower

ImProduct

ImReal

ImSin

ImSqrt

ImSub

ImSum

Index

Intercept

IntRate

Ipmt

Irr

IsErr

IsError

IsEven

IsLogical

IsNA

IsNonText

IsNumber

IsOdd

Ispmt

IsText

Kurt

Large

Lcm

LinEst

Ln

Log

Log10

LogEst

LogInv

LogNorm_Dist

LogNorm_Inv

LogNormDist

Lookup

match

Max

MDeterm

MDuration

Median

Min

MInverse

MIrr

MMult

Mode

Mode_Mult

Mode_Sngl

MRound

MultiNomial

NegBinom_Dist

NegBinomDist

NetworkDays

Nominal

Norm_Dist

Norm_Inv

Norm_S_Dist

Norm_S_Inv

NormDist

NormInv

NormSDist

NormSInv

NPer

Npv

Oct2Bin

Oct2Dec

Oct2Hex

Odd

OddFPrice

OddFYield

OddLPrice

OddLYield

Or

Pearson

Percentile

Percentile_Exc

Percentile_Inc

PercentRank

PercentRank_Exc

PercentRank_Inc

Permut

Phonetic

Pi

Pmt

Poisson

Poisson_Dist

Power

Ppmt

Price

PriceDisc

PriceMat

Prob

Product

Proper

Pv

Quartile

Quartile_Exc

Quartile_Inc

Quotient

Radians

RandBetween

Rank

Rank_Avg

Rank_Eq

Rate

Received

Replace

ReplaceB

Rept

Roman

Round

RoundDown

RoundUp

RSq

RTD

Search

SearchB

SeriesSum

Sinh

Skew

Sln

Slope

Small

SqrtPi

Standardize

StDev

StDev_P

StDev_S

StDevP

StEyx

Substitute

Subtotal

Sum

SumIf

SumIfs

SumProduct

SumSq

SumX2MY2

SumX2PY2

SumXMY2

Syd

T_Dist

T_Dist_2t

T_Dist_RT

T_Inv

T_Inv_2T

T_Test

Tanh

TBillEq

TBillPrice

TBillYield

TDist

Text

TInv

Transpose

Trend

Trim

TrimMean

TTest

USDollar

Var

Var_P

Var_S

VarP

Vdb

VLookup

Weekday

WeekNum

Weibull

Weibull_Dist

WorkDay

WorkDay_Intl

Xirr

Xnpv

YearFrac

YieldDisc

YieldMat

Z_Test

ZTest

hwc2ycy

写错符号了，你看看worksheets()后面的是“，"号，应该是"."

Shelvee

hwc2ycy 发表于 2013-2-26 20:41
查了下，average是可以调用的。

{:021:}为什么？是这个函数本来就不能被调用吗？

hwc2ycy

1. worsheets("原始数据"),range("p42:p43"))

复制代码

改成

1. worsheets("原始数据").range("p42:p43"))

复制代码

Shelvee

hwc2ycy 发表于 2013-2-26 20:45
改成

现在对了！但是只有两个数据，怎么可能两个数据都显示红色字体呢？应该还有哪里错了。。

hwc2ycy

后面的average引用范围没有加工作表前缀。

Shelvee

hwc2ycy 发表于 2013-2-26 20:54
后面的average引用范围没有加工作表前缀。

我现在改成用j表示但还是红色的。。。