Sheet1. Range (Sheet1. Cells (1, 1), Sheet1. Cells (1, 3))=Sheet2. Range (Sheet2. Cells (1, 1), Sheet2. Cells (1, 3)). The Value
The above statements can be successfully copies sheet2 in three value to sheet1

No, to the following statements is not an error, but there is no any value sheet1 A1 to C1, or empty
Sheet1. Range (Sheet1. Cells (1, 1), Sheet1. Cells (1, 3))=Sheet2. Range (Sheet2. Cells (1, 1), Sheet2. Cells (1, 3))

Could you tell me why

,,, no attachments, please understanding

CodePudding user response:

In the VBA IDE (Alt + F11 key can enter) immediately window, use the
? The variable name
Show you the value of the long expressions in the sub-expression auxiliary debugging,

CodePudding user response:

1, please make sure the A1: C1 content
2, please make sure the sheet1, sheet2 form name and code name is uniform

.

CodePudding user response:

A less value
Sheet1. Range (Sheet1. Cells (1, 1), Sheet1. Cells (1, 3))=Sheet2. Range (Sheet2. Cells (1, 1), Sheet2. Cells (1, 3)). The Value
It is ok, also can change kind of writing, a little bit more simple
Sheet1. Range (" A1: C1 ")=Sheet2. Range (" A1: C1 "). The Value
Or
Sheet3. [A1: C1]=Sheet2. [A1: C1] Value