How do I get Excel to record a macro of keystrokes?
Example in a cell
Edit
Home
Delete
Down to next cell

To repeat an answer earlier today

In a word, there is no way to get the recorder to do that.

The macro can do what you want though, you just have to modify it to do so.
For instance, to find a value, use Find

Set cell = a_specified_range.Find("value")

and then to offset it use

If Not cell Is Nothing Then

cell.Offset(2,6).Select

etc.


--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Tomg" wrote in message
...
How do I get Excel to record a macro of keystrokes?
Example in a cell
Edit
Home
Delete
Down to next cell

Sorry did not see the earlier posting when I posted.

"Bob Phillips" wrote:

To repeat an answer earlier today

In a word, there is no way to get the recorder to do that.

The macro can do what you want though, you just have to modify it to do so.
For instance, to find a value, use Find

Set cell = a_specified_range.Find("value")

and then to offset it use

If Not cell Is Nothing Then

cell.Offset(2,6).Select

etc.


--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Tomg" wrote in message
...
How do I get Excel to record a macro of keystrokes?
Example in a cell
Edit
Home
Delete
Down to next cell