Pasting in VB for excell

Closed
Tom - Dec 1, 2008 at 06:08 PM
 Tom - Dec 3, 2008 at 01:06 AM
Hello,
I tried recording a simple macro in excel that moves to a certain cell, selects many cells, cuts them, moves to a different location, and then pastes the cut cell.

However, the macro won't record the paste operation.

Here is what I have. I'd like to paste, but I can't seem to figure this out. Why doesn't excel let me record the paste operation???

' Keyboard Shortcut: Ctrl+Shift+O
'
ActiveCell.Offset(74, -1).Range("A1").Select
Range(Selection, ActiveCell.SpecialCells(xlLastCell)).Select
ActiveCell.Range("A1:A1775").Select
Selection.Cut
ActiveCell.Offset(-74, 1).Range("A1").Select

End Sub

I thought that if I simply did something like Selection.Paste or Activesheet.paste it would work, but obviously that doesn't work.
Thanks,
Tom
Related:

1 response

I just figured it out. Include this line:
ActiveSheet.Paste

that does the pasting.
Why the macro record function will not do this, I have no idea
0