| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
How do I create a macro of editing keystrokes?
I'm copying information from the Internet to paste into Excel, but the
information doesn't come in the format I want. In some cases I want to take the last 8 characters, delete them from the current cell and paste them into the next column. In other cases I want to add dashes, parentheses or spaces between so many characters. Using the record macro button only copies the data, not the keystrokes I want to repeat (e.g. in VB ActiveCell.FormulaR1C1 = "whateverIwant"). How do I create a macro that copies the keystrokes? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I create a macro button and place anywhere on my sheet? | Excel Discussion (Misc queries) | |||
| Is it possible to create a macro to group? | Excel Discussion (Misc queries) | |||
| Relative Macro Help on Keystrokes | Excel Discussion (Misc queries) | |||
| How do I create a macro to Save As? | Excel Discussion (Misc queries) | |||
| Macro and If Statement | Excel Discussion (Misc queries) | |||
Hybrid Mode
