Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro? or??
I realize that this may seem like a silly question...so be it. I'm trying to
create a macro that will perform the following keystrokes; "F2" or edit, "Home" and "Delete". What is the best way to do this? Thank you, -- David W. Heiman |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro? or??
Yes, record a Macro
IConsultIT wrote: I realize that this may seem like a silly question...so be it. I'm trying to create a macro that will perform the following keystrokes; "F2" or edit, "Home" and "Delete". What is the best way to do this? Thank you, |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro? or??
Bob,
I tried that several times and it did not record the key strokes. It merely moved what was in the first cell to the sub-sequent cells. -- David W. Heiman "Bob I" wrote: Yes, record a Macro IConsultIT wrote: I realize that this may seem like a silly question...so be it. I'm trying to create a macro that will perform the following keystrokes; "F2" or edit, "Home" and "Delete". What is the best way to do this? Thank you, |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro? or??
Apparently as soon as I hit "F2" it pauses the recording and does not record
the "F2""Home""Delete" sequence. -- David W. Heiman "IConsultIT" wrote: Bob, I tried that several times and it did not record the key strokes. It merely moved what was in the first cell to the sub-sequent cells. -- David W. Heiman "Bob I" wrote: Yes, record a Macro IConsultIT wrote: I realize that this may seem like a silly question...so be it. I'm trying to create a macro that will perform the following keystrokes; "F2" or edit, "Home" and "Delete". What is the best way to do this? Thank you, |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro? or??
Hi David
That is not the way Excel macros work. Compare Click cell A1 Click the 1 key on the keyboard Click the 2 key on the keyboard Click the Enter key on the keyboard to Range("A1").Value = 12 HTH. Best wishes Harald "IConsultIT" wrote in message ... I realize that this may seem like a silly question...so be it. I'm trying to create a macro that will perform the following keystrokes; "F2" or edit, "Home" and "Delete". What is the best way to do this? Thank you, -- David W. Heiman |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro? or??
Based on what you appear to expect to happen, use this
Sub Macro1() ActiveCell.FormulaR1C1 = Right(ActiveCell.FormulaR1C1,Len(ActiveCell.Formul aR1C1) - 1) End Sub Watch the wrap, there only 1 statement line. IConsultIT wrote: Apparently as soon as I hit "F2" it pauses the recording and does not record the "F2""Home""Delete" sequence. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro Help Needed - Excel 2007 - Print Macro with Auto Sort | Excel Worksheet Functions | |||
My excel macro recorder no longer shows up when recording macro | Excel Discussion (Misc queries) | |||
using a cell value to control a counter inside a macro and displaying macro value | Excel Worksheet Functions | |||
Macro needed to Paste Values and prevent Macro operation | Excel Discussion (Misc queries) | |||
Macro needed to Paste Values and prevent Macro operation | Excel Discussion (Misc queries) |