<?xml version="1.0" encoding="UTF-8"?>
<rss version="2.0"
	xmlns:content="http://purl.org/rss/1.0/modules/content/"
	xmlns:wfw="http://wellformedweb.org/CommentAPI/"
	xmlns:dc="http://purl.org/dc/elements/1.1/"
	xmlns:atom="http://www.w3.org/2005/Atom"
	xmlns:sy="http://purl.org/rss/1.0/modules/syndication/"
	xmlns:slash="http://purl.org/rss/1.0/modules/slash/"
	>

<channel>
	<title>exCel-LenS</title>
	<atom:link href="http://jovil.leoncio.net/?feed=rss2" rel="self" type="application/rss+xml" />
	<link>http://jovil.leoncio.net</link>
	<description>myExcel notes</description>
	<lastBuildDate>Thu, 23 Feb 2012 03:07:25 +0000</lastBuildDate>
	<language>en</language>
	<sy:updatePeriod>hourly</sy:updatePeriod>
	<sy:updateFrequency>1</sy:updateFrequency>
	<generator>http://wordpress.org/?v=3.3.1</generator>
		<item>
		<title>Using worksheet function in Macro.</title>
		<link>http://jovil.leoncio.net/?p=1</link>
		<comments>http://jovil.leoncio.net/?p=1#comments</comments>
		<pubDate>Fri, 10 Feb 2012 22:46:47 +0000</pubDate>
		<dc:creator></dc:creator>
				<category><![CDATA[Functions]]></category>
		<category><![CDATA[VBA/Macro]]></category>

		<guid isPermaLink="false">http://jovil.leoncio.net/?p=1</guid>
		<description><![CDATA[Example. Getting maximum value from A, B, or C&#8230; Application.WorksheetFunction.Max(A ,B, C) ============================================== Sub SampleWorksheetFuncMax()  A=5  B=20  C=15  MsgBox WorksheetFunction.Max(A, B, C) End Sub ============================================== List of Worksheet Functions Available to Visual Basic. The following list represents all of the worksheet functions that can be called using the WorkSheetFunction object: AccrInt, AccrIntM, Acos, Acosh, Aggregate, [...]]]></description>
			<content:encoded><![CDATA[<p>Example.<br />
Getting maximum value from A, B, or C&#8230;</p>
<p>Application.WorksheetFunction.Max(A ,B, C)</p>
<p>==============================================<br />
Sub SampleWorksheetFuncMax()</p>
<p> A=5<br />
 B=20<br />
 C=15</p>
<p> MsgBox WorksheetFunction.Max(A, B, C)</p>
<p>End Sub<br />
==============================================</p>
<p>List of Worksheet Functions Available to Visual Basic.<br />
The following list represents all of the worksheet functions that can be called using the WorkSheetFunction object:</p>
<p>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.</p>
]]></content:encoded>
			<wfw:commentRss>http://jovil.leoncio.net/?feed=rss2&#038;p=1</wfw:commentRss>
		<slash:comments>0</slash:comments>
		</item>
	</channel>
</rss>

