2 end

3 range cells, cell range

4 Msgbox output function

5 Inputbox input function

6 cells, all cells

Set of 7 worksheets (including definition names, charts and tables, etc.). )

8 worksheet Excel worksheet collection

9 workbooks Workbook collection

10 Thisworkbook: the workbook where the code is located.

1 1 active workbook active workbook

12 Ativecell

13 Dim defines variable keywords.

14 Redim redefine variable keywords.

15 integer, abbreviated as%

16 long, referred to as&;

17 single precision abbreviation!

18 abbreviations #

19 string $

20 Variants Variants, some of which are called universal variants, are variants if they are not defined.

2 1 object object

22 scope of use usable area

23 United trade unions

24 intersection intersection

25 Resize redefines the area size.

26 Current Area: Connected

27 value value

28 calls. Calls

29 Visible visibility

30 rows, all rows.

3 1 column All columns

32 Createobject Reference Dynamic Library File Function

33 dictionary dictionary

Regularization of 34 regular expressions

Excel, the tallest object in 35 applications.

36 format function

37 timer timer

38 worksheet function worksheet function

39 transpose the transpose function in the worksheet

40 Add Add

Before 4 1

Behind 42

43 key words

44 item pairs

45 Remove the empty

46 Remove All Empty All

47 Existence exists

48 counting points

49 array array function

50 save save

5 1 lower limit and upper limit

Lower limit of 52 pounds

53 Erase empty array

54 segmentation segmentation

55 connection, combination

56 filter screening

57 index worksheet reference function

58 function function

59 volatility

60 color index color index

6 1 inner shadow

62-font font

63 display display

64 uninstall and close the form

65 Onkey button event

66 punctual events

67 delete delete

68 kaikai

69 save save