Using Excel Built-in Functions in VBA

Question

Functions like MIN(), MAX(), SMALL()..

It is too bothersome for me to write codes for functions above(and much more) and do the trick.

Any help?

Excellll · Answer 1 · 2012-09-13 13:03:10Z

up vote 3 down vote

You can use the following code to use worksheet functions in VBA.

Application.WorksheetFunction.SMALL(....)

answered Sep 13 '12 at 13:03

Excellll
2,998621

Excellll · Answer 2 · 2012-09-13 23:40:10Z

up vote 2 down vote

No need for user defined codes. You can use

many WorkSheet functions directly
Use Evaluate as a workaround

MsgBox Application.WorksheetFunction.Min(Range("A1:A10"))
MsgBox Evaluate("=SMALL(A1:A10,2)")

edited Sep 13 '12 at 23:40

Excellll
2,998621

answered Sep 13 '12 at 13:06

brettdj
1,109410

	@Excellll - thx for that. I tried but couldn't get it working (!) yesterday. I've never had this issue at SO. – brettdj Sep 13 '12 at 23:16
	My SO and SU activity blends together since I mostly stick to the Excel stuff, but I've run into problem with numbered lists and code blocks before on one or the other. I had to use `<code>` tags, and as you can see, it's still not perfect. – Excellll Sep 13 '12 at 23:39

2 Answers