下面的宏语句中的Rows([i:i+2]).Select出错,请大家指点,在线等待.(50分)

I

icezs

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2003-12-27

• #1

下面的宏语句中的Rows([i:i+2]).Select出错,请大家指点,在线等待.
Do
Rows(i).Select
Selection.Insert Shift:=xlDown
Rows([i:i+2]).Select
Application.CutCopyMode = False
Selection.Copy
i = i + 4
j = j + 3
If i > j Then Exit Do
Loop

 

寻

寻找

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2003-12-27

• #2

什麼錯誤?

 

L

lidane

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2003-12-27

• #3

你将Rows([i:i+2])的()去掉试试

 

I

icezs

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2003-12-27

• #4

只提示出错.Rows[i:i+2]也不行.

 

I

icezs

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2003-12-27

• #5

我是要选择多行.记录宏后为: Rows("5:7").Select

 

I

icezs

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2003-12-27

• #6

沒有理我.

 

I

icezs

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2003-12-28

• #7

再頂.

 

I

icezs

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2003-12-29

• #8

ding

 

I

icezs

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2003-12-29

• #9

只好变通一下:
Union(rows(i),rows(i+1),rows(i+2)).Select
怎么不能给自己加分?(挣分不容易)