本帖最後由 sax868 於 2012-5-23 16:01 編輯
05222012.zip (10.85 KB)
- Sub Macro4()
- '
- ' Macro4 Macro
- '
- '
- Range("C6,C11,C13,C15,C17,C19,C21,C23,C28,C31:C33,C6").Select
- Selection.FormulaR1C1 = "=R[-1]C"
- Range("E3:E6,E8:E11,E13,E15,E17,E19,E21,E23,E25:E28,E30:E34,E3").Select
- Selection.FormulaR1C1 = "=R[-1]C"
- Cells.Select
- Selection.Copy
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
- :=False, Transpose:=False
- Rows("33:34").Select
- Application.CutCopyMode = False
- Selection.Delete Shift:=xlUp
- Range("B32").Select
- End Sub
複製代碼
各位大大午安:
請問該如何撰寫VBA,將空格填滿? 以上是我錄的巨集煩請參考
我試著寫可是不靈光:
Sub FF()
Columns("C:C").Select
Rng.Replace "", "=R[-1]C"
End Sub
拜託高手大大們幫幫我...
謝謝!
弱女子留 |