Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Two doubts for Macros
Hi to all;
I've created a Macro and this must do some actions, I've done the most of them, but there are two that I don't know what code: 1)I need to hide columns with the Macro 2)I need to insert rows with the Macro If anyone knows any of these codes it would be very great. Thanks to all; -- atrep |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Two doubts for Macros
Thypical code for those actions could be:-
Columns("A").EntireColumn.Hidden = True Rows("13:13").Insert Shift:=xlDown Mike "xavi garriga" wrote: Hi to all; I've created a Macro and this must do some actions, I've done the most of them, but there are two that I don't know what code: 1)I need to hide columns with the Macro 2)I need to insert rows with the Macro If anyone knows any of these codes it would be very great. Thanks to all; -- atrep |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Two doubts for Macros
You could have looked in the vba help
rows("1:4").hidden=true columns("a:d").hidden=true etc OR, record a macro while doing to see what happens. Then clean up -- Don Guillett Microsoft MVP Excel SalesAid Software "xavi garriga" wrote in message ... Hi to all; I've created a Macro and this must do some actions, I've done the most of them, but there are two that I don't know what code: 1)I need to hide columns with the Macro 2)I need to insert rows with the Macro If anyone knows any of these codes it would be very great. Thanks to all; -- atrep |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macros - copying macros from one computer to another | Excel Discussion (Misc queries) | |||
"openinf file..."ENABLE MACROS...DISABLE MACROS" | Excel Discussion (Misc queries) | |||
Macros | Excel Discussion (Misc queries) | |||
Training: More on how to use macros in Excel: Recording Macros | Excel Worksheet Functions | |||
I have doubts about Create Lines Charts | Charts and Charting in Excel |