Excel 2007 - Macro to do a simple cut/paste operation.

[Grindy]

Hello all,
I've done a search of this forum as well as a google and can't seem to find
exactly what I'm looking for. Here's my question:

I have a spreadsheet that contains the data exported from an Outlook contact
list that was corrupted in Outlook. The corruptions seem to follow enough of
a pattern that having an Excel macro to assist would really speed up my
"repair" of this data so I can then import it back into a new Outlook contact
list.

Here's what I want to do:
Cut the data (it's only simple text, no formulas, etc.) from a cell, move
down to the cell below, then paste that data there.
When I try to record a macro for this, it records the "cut" operation but
nothing after that. It won't record the moving down to the next cell ( I just
used the down-arrow key ), and it doesn't do the "paste".
When I look at the macro in the VB editor, I see the code for the "cut" but
that's all.

I'm sure there's something simple that I'm missing, but don't know what it is.

Any help/suggestions appreciated.

 

[Don Guillett]

As always, post your efforts
try this idea

activecell.cut activecell.offset(1)

 

[Grindy]

Thanks Don, your code works perfectly.
Can you tell me why Excel's "Record" macro doesn't seem to see the
arrow-down or paste?
bob