|
macro
How do I get Excel to record a macro of keystrokes?
Example in a cell Edit Home Delete Down to next cell |
macro
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 |
macro
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 |
| All times are GMT +1. The time now is 07:28 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com