查看完整版本: EXCEL複製時改變數值?
頁: [1]

h02049408 發表於 2016-12-26 03:14 PM

EXCEL複製時改變數值?

r = ActiveSheet..End(3).Row
y = 1
For i = 1 To r
Next i
Range("A1:AN" & i).Copy
ActiveSheet.Paste Destination:=Range("AP" & y)
y = y + 1

請教大師們 !
如何編寫?把下列的語法,在複製時代進來,然後貼上...謝謝!

改變數值的型式:"(Cells(i, 9 * 2), Cells(i, 12 * 3), Cells(i, 15 *4),,,,,"

實際需求:For j = 9 To 33 Step 3
...<div class='locked'><em>瀏覽完整內容，請先 <a href='member.php?mod=register'>註冊</a> 或 <a href='javascript:;' onclick="lsSubmit()">登入會員</a></em></div><div></div>
頁: [1]