Current location - Plastic Surgery and Aesthetics Network - Plastic surgery and beauty - Excel table programming statement, please help me explain the meaning of the following statement, thank you.
Excel table programming statement, please help me explain the meaning of the following statement, thank you.
This program copies the contents of table 1 line by line to the corresponding cells in table 2 and prints them independently.

Child xx ()

"Dimlastrow as long" defines the variable type.

Lastrow = range ("B65536 ")。 End (XLUP). Row ()' reads the line number of the last line of Sheet 1.

Paper ("Paper 2"). Select Select Worksheet 2.

Take the contents of Sheet 1 from the second line to the last line.

For j = 2 to 8' Take the contents of a row from columns 2 to 8.

Cells (j+3,3) = sheet 1。 Cell (i, j)' is in the third column, row 5- 1 1.

Next J.

For the contents of columns with j = 9 to 13' from 9 to 13.

Cell (j-4,6) = sheet1. The cell (i, j)' is placed in the 6th column, rows 5-9.

Next J.

Cell (14,6) = sheet1. Cell (I, 14)' gets the contents of columns 13 to 14.

Cell (1 3,6) = worksheet1. The cell (I, 15)' will divide the rows in the sixth column into 14 and 13.

Active window. The selected worksheet. PrintoutCopies: = 1' Prints the contents of the worksheet.

What is the next line?

End joint