Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Converting code to function
Hello,
I have a procedure that perform often that I would like to convert into a function called "DASHES". All it does is take a 10-digit number in a cell and insert dashes into the appropriate places, and save the result. I did a macro to get the code, but I don't know how to turn this into a function that will be available every time I use my copy of Excel. Here is the code: Sub DASHES() ' ' DASHES Macro ' Macro recorded 10/15/2008 by Dino ' ActiveCell.FormulaR1C1 = _ "=LEFT(RC[-1],4)&""-""&MID(RC[-1],5,3)&""-""&RIGHT(RC[-1],3)" Range("C3").Select Selection.Copy Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:= _ False, Transpose:=False End Sub Any help would be appreciated, thanks! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
converting formulas to code | New Users to Excel | |||
converting a simple formula into VBA code | Excel Programming | |||
Needs help converting some pseudo code into VB code | Excel Programming | |||
UDF problem in converting data into code 128 B | Excel Worksheet Functions | |||
Converting code to R1C1 format | Excel Programming |