Jim,

Thanks for the post. I'll try out your suggestion.

I am not thinking of 1-2-3. Back in the windows 3.x and perhaps 95 days, MS
had a key stroke recorder. I think it was named either Script or Recorder.
It worked in one or two versions of Windows after MS dropped it in favor of
the programing languages, but eventually stopped working in a subsequent
version.

I use to do some basic programing with QuickBasic, but never made the
transition to Visual Basic. I really hated that Bill Gates dropped the
keystroke recorder in favor of the key action recorder. Over the last 20
years or so, I've wasted tons and tons of time that having a keystroke
recorder could have saved.

I realize that the programing languages are powerful, but if you don't know
how to use them, your stuck!
--
DonDCajun


"Jim Rech" wrote:

VBA, and the Excel 4 macro language before it, is and always was a
programming language. Perhaps you were thinking of 1-2-3.

Anyway, this does what I think you want:

With ActiveCell
.Offset(-1).Formula = .Formula
.ClearContents
End With


--
Jim
"DonD''Cajun" wrote in message
...
Has Micorsoft ever added back the functionality of recording keystrokes
instead of keystroke actions?

I am trying to massage a large text file that I've brought into Excel.
Excel makes it easy to compare one file with another.

I record a macro to:
F2 to Edit a cell,
SHIFT + HOME to select all of the text in the cell,
CTRL-X to MOVE the text into the clipboard,
UP ARROW to get to the above cell,
F2 to edit this cell
CTRL+V to paste previously copied text to this cell
and ENTER to finalize this cell

When I play this back on the next pair of cells, either the concatentated
text of the forst cell ends up in the new cell, or the text that was in
the
original first cell is copied to the end of the new second cell.

When I look at the Macro editor, I see not keystrokes but keystroke
actions.
Seems like there was a script editor that use to do what I'm looking for,
but I guess Mr. Gates eliminated this many Excel versions ago.

Can any one help?

--
DonD'Cajun