VBA or Excel

The following table lists all the Excel worksheet functions which are available.
For a general rule, if there is an identical VBA Function then the Excel function is not available.
It also highlights when there is an alternative VBA Functions.
The asterisk denotes when the VBA function has a different name to the Excel function.
link - support.microsoft.com/en-gb/help/213660/not-all-excel-worksheet-functions-are-supported-as-methods-of-the-appl

Function	Excel (WorksheetFunction.)	VBA (VBA.)
ABS	ABS	ABS
ACCRINT	ACCRINT
ACCRINTM	ACCRINTM
ACOS	ACOS
ACOSH	ACOSH
ACOT	ACOT
ACOTH	ACOTH
ADDRESS	ADDRESS
AGGREGATE	AGGREGATE
AMORDEGRC	AMORDEGRC
AMORLINC	AMORLINC
AND	AND	AND - Operator
ARABIC	ARABIC
AREAS	AREAS
ARRAYTOTEXT	ARRAYTOTEXT
ASC	ASC
		ASC
ASIN	ASIN
ASINH	ASINH
ATAN*	ATAN	ATN
ATAN2	ATAN2
ATANH	ATANH
ATN*	ATAN	ATN
AVEDEV	AVEDEV
AVERAGE	AVERAGE
AVERAGEA	AVERAGEA
AVERAGEIF	AVERAGEIF
AVERAGEIFS	AVERAGEIFS
BAHTTEXT	BAHTTEXT
BASE	BASE
BESSELI	BESSELI
BESSELJ	BESSELJ
BESSELK	BESSELK
BESSELY	BESSELY
BETA.DIST	BETA.DIST
BETA.INV	BETA.INV
BIN2DEC	BIN2DEC
BIN2HEX*	BIN2HEX	HEX
BIN2OCT*	BIN2OCT	OCT
BINOM.DIST	BINOM.DIST
BINOM.DIST.RANGE	BINOM.DIST.RANGE
BINOM.INV	BINOM.INV
BITAND	BITAND
BITLSHIFT	BITLSHIFT
BITOR	BITOR
BITRSHIFT	BITRSHIFT
BITXOR	BITXOR
BYCOL	BYCOL
BYROW	BYROW
CALL	CALL
CEILING.MATH	CEILING.MATH
CELL	CELL
CHAR*	CHAR	CHR
CHISQ.DIST	CHISQ.DIST
CHISQ.DIST.RT	CHISQ.DIST.RT
CHISQ.INV	CHISQ.INV
CHISQ.INV.RT	CHISQ.INV.RT
CHISQ.TEST	CHISQ.TEST
CHOOSE	CHOOSE	CHOOSE
CHOOSECOLS	CHOOSECOLS
CHOOSEROWS	CHOOSEROWS
CHR*	CHAR	CHR
CLEAN	CLEAN
CODE	CODE
COLUMN	COLUMN
COLUMNS	COLUMNS
COMBIN	COMBIN
COMBINA	COMBINA
COMMAND		COMMAND
COMPLEX	COMPLEX
CONCATENATE	CONCATENATE	&
CONFIDENCE.NORM	CONFIDENCE.NORM
CONFIDENCE.T	CONFIDENCE.T
CONVERT	CONVERT
CORREL	CORREL
COS	COS	COS
COSH	COSH
COT	COT
COTH	COTH
COUNT	COUNT
COUNTA	COUNTA
COUNTBLANK	COUNTBLANK
COUNTIF	COUNTIF
COUNTIFS	COUNTIFS
COUPDAYBS	COUPDAYBS
COUPDAYS	COUPDAYS
COUPDAYSNC	COUPDAYSNC
COUPNCD	COUPNCD
COUPNUM	COUPNUM
COUPPCD	COUPPCD
COVARIANCE.P	COVARIANCE.P
COVARIANCE.S	COVARIANCE.S
CRITBINOM	CRITBINOM
CSC	CSC
CSCH	CSCH
CUBEKPIMEMBER	CUBEKPIMEMBER
CUBEMEMBER	CUBEMEMBER
CUBESET	CUBESET
CUBESETCOUNT	CUBESETCOUNT
CUBEVALUE	CUBEVALUE
CUMIPMT	CUMIPMT
CUMPRINC	CUMPRINC
DATE*	DATE	DATESERIAL
DATEADD		DATEADD
DATEDIF	DATEDIF
DATEDIFF		DATEDIFF
DATEPART		DATEPART
DATESERIAL*	DATE	DATESERIAL
DATEVALUE		DATEVALUE
DAVERAGE	DAVERAGE
DAY		DAY
DAYS	DAYS
DAYS360	DAYS360
DB	DB
DBCS	DBCS
DCOUNT	DCOUNT
DCOUNTA	DCOUNTA
DDB	DDB	DDB
DEC2BIN	DEC2BIN
DEC2HEX	DEC2HEX
DEC2OCT	DEC2OCT
DECIMAL	DECIMAL
DEGREES	DEGREES
DELTA	DELTA
DEVSQ	DEVSQ
DGET	DGET
DISC	DISC
DMAX	DMAX
DMIN	DMIN
DOLLAR	DOLLAR
DOLLARDE	DOLLARDE
DOLLARFR	DOLLARFR
DROP	DROP
DPRODUCT	DPRODUCT
DSTDEV	DSTDEV
DSTDEVP	DSTDEVP
DSUM	DSUM
DURATION	DURATION
DVAR	DVAR
DVARP	DVARP
EDATE	EDATE
EFFECT	EFFECT
ENCODEURL	ENCODEURL
EOMONTH	EOMONTH
ERF	ERF
ERF.PRECISE	ERF.PRECISE
ERFC.PRECISE	ERFC.PRECISE
ERROR.TYPE	ERROR.TYPE
EUROCONVERT	EUROCONVERT
EVEN	EVEN
EXACT	EXACT
EXP		EXP
EXPON.DIST	EXPON.DIST
F.DIST	F.DIST
F.DIST.RT	F.DIST.RT
F.INV	F.INV
F.INV.RT	F.INV.RT
F.TEST	F.TEST
FACT	FACT
FACTDOUBLE	FACTDOUBLE
FALSE	FALSE
FIELDVALUE	FIELDVALUE
FILTER		FILTER
FILTERXML	FILTERXML
FIND	FIND
FISHER	FISHER
FISHERINV	FISHERINV
FIX		FIX
FIXED	FIXED
FLOOR.MATH	FLOOR.MATH
FLOOR.PRECISE	FLOOR.PRECISE
FORECAST	FORECAST
FORECAST.ETS	FORECAST.ETS
FORECAST.LINEAR	FORECAST.LINEAR
FORMAT		FORMAT
FORMATCURRENCY		FORMATCURRENCY
FORMATDATETIME		FORMATDATETIME
FORMATNUMBER		FORMATNUMBER
FORMATPERCENT		FORMATPERCENT
FORMULATEXT	FORMULATEXT
FREQUENCY	FREQUENCY
FV	FV	FV
GAMMA	GAMMA
GAMMA.DIST	GAMMA.DIST
GAMMA.INV	GAMMA.INV
GAMMALN.PRECISE	GAMMALN.PRECISE
GAUSS	GAUSS
GCD	GCD
GEOMEAN	GEOMEAN
GESTEP	GESTEP
GETPIVOTDATA	GETPIVOTDATA
GROWTH	GROWTH
HARMEAN	HARMEAN
HEX*	BIN2HEX	HEX
HEX2BIN	HEX2BIN
HEX2DEC	HEX2DEC
HEX2OCT	HEX2OCT
HLOOKUP	HLOOKUP
HOUR	HOUR	HOUR
HSTACK	HSTACK
HYPERLINK	HYPERLINK
HYPGEOM.DIST	HYPGEOM.DIST
IF	IF
IFERROR	IFERROR
IFNA	IFNA
IFS	IFS
IMABS	IMABS
IMAGINARY	IMAGINARY
IMARGUMENT	IMARGUMENT
IMCONJUGATE	IMCONJUGATE
IMCOS	IMCOS
IMCOSH	IMCOSH
IMCOT	IMCOT
IMCSC	IMCSC
IMCSCH	IMCSCH
IMDIV	IMDIV
IMEXP	IMEXP
IMLN	IMLN
IMLOG10	IMLOG10
IMLOG2	IMLOG2
IMPOWER	IMPOWER
IMPRODUCT	IMPRODUCT
IMREAL	IMREAL
IMSEC	IMSEC
IMSECH	IMSECH
IMSIN	IMSIN
IMSINH	IMSINH
IMSQRT	IMSQRT
IMSUB	IMSUB
IMSUM	IMSUM
IMTAN	IMTAN
INDEX	INDEX
INDIRECT	INDIRECT
INFO	INFO
INPUT		INPUT - Function
INPUT		INPUT - Statement
INSTR		INSTR
INSTRREV		INSTRREV
INT	INT	INT
INTERCEPT	INTERCEPT
INTRATE	INTRATE
IPMT	IPMT	IPMT
IRR	IRR	IRR
IS		IS
ISARRAY		ISARRAY
ISBLANK	ISBLANK
ISDATE		ISDATE
ISEMPTY		ISEMPTY
ISERR	ISERR
ISERROR	ISERROR	ISERROR
ISEVEN	ISEVEN
ISFORMULA	Added in 2013
ISLOGICAL	ISLOGICAL
ISMISSING		ISMISSING
ISNA	ISNA
ISNONTEXT	ISNONTEXT
ISNULL		ISNULL
ISNUMBER	ISNUMBER
ISNUMERIC		ISNUMERIC
ISOBJECT		ISOBJECT
ISODD	ISODD
ISOMITTED	ISOMITTED
ISOWEEKNUM	ISOWEEKNUM
ISPMT	ISPMT
ISREF	ISREF
ISTEXT	ISTEXT
JOIN		JOIN
KURT	KURT
LAMBDA	LAMBDA
LARGE	LARGE
LCASE	LOWER	LCASE
LCM	LCM
LEFT	LEFT	LEFT
LEN	LEN	LEN
LET	LET
LINEST	LINEST
LN*	LN	LOG
LOG	LOG
		LOG
LOG10	LOG10
LOGEST	LOGEST
LOGNORM.DIST	LOGNORM.DIST
LOGNORM.INV	LOGNORM.INV
LOOKUP	LOOKUP
LOWER	LOWER	LCASE
LSET		LSET
LTRIM		LTRIM
MAKEARRAY	MAKEARRAY
MAP	MAP
MATCH	MATCH
MAX	MAX
MAXA	MAXA
MAXIFS	MAXIFS
MDETERM	MDETERM
MDURATION	MDURATION
MEDIAN	MEDIAN
MID	MID	MID
MIN	MIN
MINA	MINA
MINIFS	MINIFS
MINUTE	MINUTE	MINUTE
MINVERSE	MINVERSE
MIRR	MIRR	MIRR
MMULT	MMULT
MOD	MOD	MOD - Operator
MODE.MULT	MODE.MULT
MODE.SNGL	MODE.SNGL
MONTH	MONTH	MONTH
MONTHNAME		MONTHNAME
MROUND	MROUND
MULTINOMIAL	MULTINOMIAL
MUNIT	MUNIT
N	N
NA	NA
NEGBINOM.DIST	NEGBINOM.DIST
NETWORKDAYS.INTL	NETWORKDAYS.INTL
NOMINAL	NOMINAL
NORM.DIST	NORM.DIST
NORM.INV	NORM.INV
NORM.S.DIST	NORM.S.DIST
NORM.S.INV	NORM.S.INV
NOT	NOT	NOT - Operator
NOW	NOW	NOW
NPER	NPER	NPER
NPV	NPV	NPV
NUMBERVALUE	NUMBERVALUE
OCT*	BIN2OCT	OCT
OCT2BIN	OCT2BIN
OCT2DEC	OCT2DEC
OCT2HEX	OCT2HEX
ODD	ODD
ODDFPRICE	ODDFPRICE
ODDFYIELD	ODDFYIELD
ODDLPRICE	ODDLPRICE
ODDLYIELD	ODDLYIELD
OFFSET	OFFSET
OR	OR	OR - Operator
PARTITION		PARTITION
PDURATION	PDURATION
PEARSON	PEARSON
PERCENTILE.EXC	PERCENTILE.EXC
PERCENTILE.INC	PERCENTILE.INC
PERCENTRANK.EXC	PERCENTRANK.EXC
PERCENTRANK.INC	PERCENTRANK.INC
PERMUT	PERMUT
PERMUTATIONA	PERMUTATIONA
PHI	PHI
PHONETIC	PHONETIC
PI	PI
PMT	PMT	PMT
POISSON.DIST	POISSON.DIST
POWER	POWER
PPMT	PPMT	PPMT
PRICE	PRICE
PRICEDISC	PRICEDISC
PRICEMAT	PRICEMAT
PROB	PROB
PRODUCT	PRODUCT
PROPER	PROPER
PUT		PUT
PV	PV	PV
QBCOLOR		QBCOLOR
QUARTILE.EXC	QUARTILE.EXC
QUARTILE.INC	QUARTILE.INQ
QUOTIENT	QUOTIENT
RADIANS	RADIANS
RAND*	RAND	RND
RANDARRAY	RANDARRAY
RANDBETWEEN	RANDBETWEEN
RANK.AVG	RANK.AVG
RANK.EQ	RANK.EQ
RATE	RATE	RATE
RECEIVED	RECEIVED
REDUCE	REDUCE
REPLACE	REPLACE	REPLACE
REPT	REPT
RIGHT	RIGHT	RIGHT
RND*	RAND	RND
ROMAN	ROMAN
ROUND	ROUND	ROUND
ROUNDDOWN	ROUNDDOWN
ROUNDUP	ROUNDUP
ROW	ROW
ROWS	ROWS
RRI	RRI
RSET		RSET
RSQ	RSQ
RTD	RTD
RTRIM		RTRIM
SCAN	SCAN
SEARCH	SEARCH
SEC	SEC
SECH	SECH
SECOND	SECOND	SECOND
SEQUENCE	SEQUENCE
SENDKEYS		SENDKEYS
SERIESSUM	SERIESSUM
SETATTR		SETATTR
SGN*	SIGN	SGN
SHEET	SHEET
SHEETS	SHEETS
SHELL		SHELL
SIGN*	SIGN	SGN
SIN	SIN	SIN
SINH	SINH
SKEW	SKEW
SKEW.P	SKEW.P
SLN	SLN	SLN
SLOPE	SLOPE
SMALL	SMALL
SORT	SORT
SORTBY	SORTBY
SPACE		SPACE
SPLIT		SPLIT
SQR*	SQRT	SQR
SQRT*	SQRT	SQR
SQRTPI	SQRTPI
STANDARDIZE	STANDARDIZE
STDEV.P	STDEV.P
STDEV.S	STDEV.S
STDEVA	STDEVA
STDEVPA	STDEVPA
STEYX	STEYX
STOCKHISTORY	STOCKHISTORY
STR		STR
STRCOMP		STRCOMP
STRCONV		STRCONV
STRING		STRING
STRREVERSE		STRREVERSE
SUBSTITUTE	SUBSTITUTE
SUBTOTAL	SUBTOTAL
SUM	SUM
SUMIF	SUMIF
SUMIFS	SUMIFS
SUMPRODUCT	SUMPRODUCT
SUMSQ	SUMSQ
SUMX2MY2	SUMX2MY2
SUMX2PY2	SUMX2PY2
SUMXMY2	SUMXMY2
SWITCH	SWITCH
SYD	SYD	SYD
T	T
T.DIST	T.DIST
T.DIST.2T	T.DIST.2T
T.DIST.RT	T.DIST.RT
T.INV	T.INV
T.INV.2T	T-INV-2T
T.TEST	T.TEST
TAN	TAN	TAN
TANH	TANH
TBILLEQ	TBILLEQ
TBILLPRICE	TBILLPRICE
TBILLYIELD	TBILLYIELD
TEXT	TEXT
TEXTAFTER	TEXTAFTER
TEXTBEFORE	TEXTBEFORE
TEXTJOIN	TEXTJOIN
TEXTSPLIT	TEXTSPLIT
TIME*	TIME	TIMESERIAL
TIMER		TIMER
TIMESERIAL*	TIME	TIMESERIAL
TIMEVALUE		TIMEVALUE
TOCOL	TOCOL
TODAY*	TODAY	DATE - Function
TOROW	TOROW
TRANSPOSE	TRANSPOSE
TREND	TREND
TRIM	TRIM	TRIM
TRIMMEAN	TRIMMEAN
TRUE	TRUE
TRUNC	TRUNC
TYPE	TYPE
UCASE*	UPPER	UCASE
UNICHAR	UNICHAR
UNICODE	UNICODE
UNIQUE	UNIQUE
UPPER*	UPPER	UCASE
VAL		VAL
VALUETOTEXT	VALUETOTEXT
VAR.P	VAR.P
VAR.S	VAR.S
VARA	VARA
VARPA	VARPA
VDB	VDB
VLOOKUP	VLOOKUP
VSTACK	VSTACK
WEBSERVICE	WEBSERVICE
WEEKDAY	WEEKDAY	WEEKDAY
WEEKDAYNAME		WEEKDAYNAME
WEEKNUM	WEEKNUM
WEIBULL.DIST	WEIBULL.DIST
WORKDAY.INTL	WORKDAY.INTL
WRAPCOLS	WRAPCOLS
WRAPROWS	WRAPROWS
XIRR	XIRR
XLOOKUP	XLOOKUP
XMATCH	XMATCH
XNPV	XNPV
XOR	XOR
YEAR	YEAR	YEAR
YEARFRAC	YEARFRAC
YIELD	YIELD
YIELDDISC	YIELDDISC
YIELDMAT	YIELDMAT
Z.TEST	Z-TEST