VBA call in Excel

1. Use the cell formula to return the value.

sub t5()

range("d16") = evaluate("=sumif(a2:a6,""b"",b2:b6)") 'Macro table functions directly convert formula expressions into numeric values.

range("d9") = evaluate("=sum(b2:b6*c2:c6)")

end sub

2. Borrow worksheet functions.

sub t6()

range("d8") = "a1:a10"), "b")end sub'

3. Use VBA functions.

sub t7()

range("c20") = "a20"), "e")end sub

dim sht as worksheet

for each sht in worksheetsif <>"New worksheet" then

Fixed columns. copy 'For example, column A is replaced by fixed column"a:a")sheets("New worksheet").

columnsinsert shift:=xltoright 'If inserted in column A, put it"columns"Changed to"a:

a"end if

next

Need specific documentation, what are the fixed columns?

VBA** in Excel needs to be used in the VBE window (see detailed analysis below).

Excel version reference: 2010

1. Alt+F11 to enter the VBE dialog box.

2. Right-click - Insert - Module.

3. Enter**(use the existing **, copy and paste it directly) 4. Press F5 to run or click the triangle button to run**.

5. Check the effect.

Method The steps are as follows:

1. Double-click to open the Excel on the desktop;

2. Click the office icon in the upper right corner, find the excel option, and click open;

3. Select Show the "Development Tools" tab in the ribbon and click the OK button to complete the modification.

4. Click the development tools in the menu bar, and then find Visual Basic and click to open to carry out related VBA programming.

ExcelHome's VBA learning version, I hope you can find what you want to learn in it.

If you can do without VBA, you don't use it. Troublesome.

Software version: Office 2013

Here's how:1Use VBA to sum the data in column C:

Enter ** as follows:

Execute ** and the result is as follows:

worksheetfunction.This is followed by the name of the function you want to call.