Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help w/ getting F2 into a macro
I have an Excel 2000 speadsheet with 9000 rows of data which someone
imported from some other software. The one column should contain numeric data, but the import left it with some preceding spaces and a following asterisk. This needs to be converted to numerical format which can be referenced by formulae. I really don't want to plow through 9000 lines and am trying to set up a macro to do this. The following keystrokes have the right effect. F2 (function key to go to edit mode) Backspace (to delete the training asterisk character) Enter (which writes back to the cell and moves the cursor to the next cell below) My problem in creating the macro a 1. How to get the Macro Record to record an F2 depress 2. How to get the macro to loop I guess I can just stop it with Ctrl-C when it gets past line 9000 Could someone clip some code here please that I can just paste into the Macro Editor.? thanks for the help .les. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Search, Copy, Paste Macro in Excel | Excel Worksheet Functions | |||
Can T Get Macro To Run! | New Users to Excel | |||
Closing File Error | Excel Discussion (Misc queries) | |||
Playing a macro from another workbook | Excel Discussion (Misc queries) | |||
Date macro | Excel Discussion (Misc queries) |