Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
macro
How do I get Excel to record a macro of keystrokes?
Example in a cell Edit Home Delete Down to next cell |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Search, Copy, Paste Macro in Excel | Excel Worksheet Functions | |||
Closing File Error | Excel Discussion (Misc queries) | |||
macro with F9 | Excel Discussion (Misc queries) | |||
Make Alignment options under format cells available as shortcut | Excel Discussion (Misc queries) | |||
Playing a macro from another workbook | Excel Discussion (Misc queries) |