G Guest Jul 5, 2006 #1 How do I get Excel to record a macro of keystrokes? Example in a cell Edit Home Delete Down to next cell
How do I get Excel to record a macro of keystrokes? Example in a cell Edit Home Delete Down to next cell
B Bob Phillips Jul 5, 2006 #2 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)
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)
