Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel,microsoft.public.excel.misc,microsoft.public.excel.programming
|
|||
|
|||
Excel macro -example
Where can i view the code of an example of a macro that rearranges columns
in excel ? Thanks in advance Yanchri |
#2
Posted to microsoft.public.excel,microsoft.public.excel.misc,microsoft.public.excel.programming
|
|||
|
|||
Excel macro -example
Hi
Record one using the macro recorder ... tools / macro / record new macro to view the code tools / macro / macros, click on the one you created and choose edit Regards julieD "Yanchri Gerber" wrote in message ... Where can i view the code of an example of a macro that rearranges columns in excel ? Thanks in advance Yanchri |
#3
Posted to microsoft.public.excel,microsoft.public.excel.misc,microsoft.public.excel.programming
|
|||
|
|||
Excel macro -example
Maybe i'm misreading something.
But what i actually want is an example of a macro, already created. Then i want to view the code. Thanks Yanchri "JulieD" wrote in message ... Hi Record one using the macro recorder ... tools / macro / record new macro to view the code tools / macro / macros, click on the one you created and choose edit Regards julieD |
#4
Posted to microsoft.public.excel,microsoft.public.excel.misc,microsoft.public.excel.programming
|
|||
|
|||
Excel macro -example
Hi
if you record one then you will be able see the code (and make some sense of it as you'll know what you did to cause the code to be written the way it is) .. other than that maybe someone else will be able to provide this for you. Regards JulieD "Yanchri Gerber" wrote in message ... Maybe i'm misreading something. But what i actually want is an example of a macro, already created. Then i want to view the code. Thanks Yanchri "JulieD" wrote in message ... Hi Record one using the macro recorder ... tools / macro / record new macro to view the code tools / macro / macros, click on the one you created and choose edit Regards julieD |
#5
Posted to microsoft.public.excel,microsoft.public.excel.misc,microsoft.public.excel.programming
|
|||
|
|||
Excel macro -example
Sub MoveColumn()
' moved column E before Column B Dim rng As Range Set rng = Columns(5) rng.Cut Columns(2).Insert End Sub -- Regards, Tom Ogilvy "Yanchri Gerber" wrote in message ... Maybe i'm misreading something. But what i actually want is an example of a macro, already created. Then i want to view the code. Thanks Yanchri "JulieD" wrote in message ... Hi Record one using the macro recorder ... tools / macro / record new macro to view the code tools / macro / macros, click on the one you created and choose edit Regards julieD |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
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) | |||
Excel Macro Issue Trying to autorun Macro Upon Opening Worksheet | Excel Programming |