Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Make a macro of keystrokes. ie. F2,Shift & Home & right cursor,de.
in excel macros seem to just copy the RESULTS of a macro performed on one
cell to another cell. what I need a macro to do is to perform the keystrokes in the new cell. The keystrokes above will remove all the spaces in a cell execpt for the first one. I don't want to effect whatever character is in that first cell. the macro's i've created only copy the contents of the 1st character from the cell which created the macro to wht new cell where the macro is run. Excel Office XP |
#2
|
|||
|
|||
Hi
could you explain what your expected result is with an example. Could be done with a formula or a macro using Instr, Left, Mid -- Regards Frank Kabel Frankfurt, Germany "Ted Byrd" <Ted schrieb im Newsbeitrag ... in excel macros seem to just copy the RESULTS of a macro performed on one cell to another cell. what I need a macro to do is to perform the keystrokes in the new cell. The keystrokes above will remove all the spaces in a cell execpt for the first one. I don't want to effect whatever character is in that first cell. the macro's i've created only copy the contents of the 1st character from the cell which created the macro to wht new cell where the macro is run. Excel Office XP |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to program an excel macro to repeat a series of keystrokes? | Excel Discussion (Misc queries) | |||
How do I create a macro of editing keystrokes? | Excel Discussion (Misc queries) | |||
Relative Macro Help on Keystrokes | Excel Discussion (Misc queries) | |||
Macro or Function to make text size to suite text Length? | Excel Discussion (Misc queries) |