Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help with Macro
I am not very good at VB and need some help with a
Macro. I have spread sheet that is exported from another program. We need to reformat the data in Column B. The data comes into excell like this " 131212A" It needs to look like this "13-1212A". I have tried the standard recored macro, however it just replaces the data with the hard coded value. I need this to be able to handle diffrent values in column B. Any ideas would really help, I think this easy, I'm just not a vb guy. Thans Chad |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro recorded... tabs & file names changed, macro hangs | Excel Worksheet Functions | |||
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) | |||
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 |