Chr(charcode),ChrB,ChrW,第一个ANSI,第二个Unicode Asc(string),AscB,AscW Instr([start, ]string1, string2[, compare]) compare取值
Len(string| varname) Replace(expression, find, replace[, start[, count[, compare]]]) UBounde(arrayname[, dimension]) LBounde返回指定维的最大上小标,计算维数要+1 Split(expression[, delimiter[, limit[, compare]]]) Weekday(date, [firstdayofweek]), day为日期的Variant、数值表达式、字符串或它们的组合,例如”2014年3月24”、”2014/3/24”、#3/24/2014# DateDiff(interval, date1, date2[, firstdayofweek[, firstweekofyear]]) interval取值
Dateserial(year, month, day)返回一个Variant数值,如Dateserial(2014,3,24)返回2014/3/24 Array(arglist), IsArray() Match(lookup_value, lookup_array,match_type) match_type取值
Countif(range, criteria), criteria可以为32, “32”, “>32”, “apples” Filter(sourcearray, match[, include[, compare]]) 该函数部分匹配 match=true返回包含match的数 Tranpose(array)只能作用于下标从1开始的二维或者一维数组 Round(expression[, numdecimalplaces])是Banker舍入 Application.WorkSheetsFunction.Round(n,d)是算术舍入 IsError(expression) IIf(expr, truepart, falsepart) Vlookup(lookup_value, table_array, col_index_num, range_lookup) range_lookup=true近似匹配,false精确匹配 Hex(string)返回代表16进制的string Right(string, length) Left Val(string)返回字符串内的数字 Format(expression[, format[, firstdayofweek[, firstweekofyear]]]) |
|
来自: yuzhoushenling > 《VBA》