Note
Access to this page requires authorization. You can try signing in or .
Access to this page requires authorization. You can try .
Excel.RangeReference interface
- Package:
- excel
Represents a string reference of the form "SheetName!A1:B5", or a global or local named range.
Remarks
Used by
- Excel.Functions: abs, accrInt, accrIntM, acos, acosh, acot, acoth, amorDegrc, amorLinc, and, arabic, areas, asc, asin, asinh, atan, atan2, atanh, aveDev, average, averageA, averageIf, averageIfs, bahtText, base, besselI, besselJ, besselK, besselY, beta_Dist, beta_Inv, bin2Dec, bin2Hex, bin2Oct, binom_Dist, binom_Dist_Range, binom_Inv, bitand, bitlshift, bitor, bitrshift, bitxor, ceiling_Math, ceiling_Precise, char, chiSq_Dist, chiSq_Dist_RT, chiSq_Inv, chiSq_Inv_RT, choose, clean, code, columns, combin, combina, complex, concatenate, confidence_Norm, confidence_T, convert, cos, cosh, cot, coth, count, countA, countBlank, countIf, countIfs, coupDayBs, coupDays, coupDaysNc, coupNcd, coupNum, coupPcd, csc, csch, cumIPmt, cumPrinc, date, datevalue, daverage, day, days, days360, db, dbcs, dcount, dcountA, ddb, dec2Bin, dec2Hex, dec2Oct, decimal, degrees, delta, devSq, dget, disc, dmax, dmin, dollar, dollarDe, dollarFr, dproduct, dstDev, dstDevP, dsum, duration, dvar, dvarP, ecma_Ceiling, edate, effect, eoMonth, erf, erf_Precise, erfC, erfC_Precise, error_Type, even, exact, exp, expon_Dist, f_Dist, f_Dist_RT, f_Inv, f_Inv_RT, fact, factDouble, find, findB, fisher, fisherInv, fixed, floor_Math, floor_Precise, fv, fvschedule, gamma, gamma_Dist, gamma_Inv, gammaLn, gammaLn_Precise, gauss, gcd, geoMean, geStep, harMean, hex2Bin, hex2Dec, hex2Oct, hlookup, hour, hyperlink, hypGeom_Dist, if, imAbs, imaginary, imArgument, imConjugate, imCos, imCosh, imCot, imCsc, imCsch, imDiv, imExp, imLn, imLog10, imLog2, imPower, imProduct, imReal, imSec, imSech, imSin, imSinh, imSqrt, imSub, imSum, imTan, int, intRate, ipmt, irr, isErr, isError, isEven, isFormula, isLogical, isNA, isNonText, isNumber, iso_Ceiling, isOdd, isoWeekNum, ispmt, isref, isText, kurt, large, lcm, left, leftb, len, lenb, ln, log, log10, logNorm_Dist, logNorm_Inv, lookup, lower, match, max, maxA, mduration, median, mid, midb, min, minA, minute, mirr, mod, month, mround, multiNomial, n, negBinom_Dist, networkDays, networkDays_Intl, nominal, norm_Dist, norm_Inv, norm_S_Dist, norm_S_Inv, not, nper, npv, numberValue, oct2Bin, oct2Dec, oct2Hex, odd, oddFPrice, oddFYield, oddLPrice, oddLYield, or, pduration, percentile_Exc, percentile_Inc, percentRank_Exc, percentRank_Inc, permut, permutationa, phi, pmt, poisson_Dist, power, ppmt, price, priceDisc, priceMat, product, proper, pv, quartile_Exc, quartile_Inc, quotient, radians, randBetween, rank_Avg, rank_Eq, rate, received, replace, replaceB, rept, right, rightb, roman, round, roundDown, roundUp, rows, rri, sec, sech, second, seriesSum, sheet, sheets, sign, sin, sinh, skew, skew_p, sln, small, sqrt, sqrtPi, standardize, stDev_P, stDev_S, stDevA, stDevPA, substitute, subtotal, sum, sumIf, sumIfs, sumSq, syd, t, t_Dist, t_Dist_2T, t_Dist_RT, t_Inv, t_Inv_2T, tan, tanh, tbillEq, tbillPrice, tbillYield, text, time, timevalue, trim, trimMean, trunc, type, unichar, unicode, upper, usdollar, value, var_P, var_S, varA, varPA, vdb, vlookup, weekday, weekNum, weibull_Dist, workDay, workDay_Intl, xirr, xnpv, xor, year, yearFrac, yield, yieldDisc, yieldMat, z_Test
Properties
| address | The address of the range, for example "SheetName!A1:B5". |
Property Details
address
The address of the range, for example "SheetName!A1:B5".
address: string;
Property Value
string
Remarks
Collaborate with us on GitHub
The source for this content can be found on GitHub, where you can also create and review issues and pull requests. For more information, see our contributor guide.
Office Add-ins
Feedback
Was this page helpful?
