Two doubts for Macros

X

xavi garriga

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;
 
M

Mike H

Thypical code for those actions could be:-

Columns("A").EntireColumn.Hidden = True
Rows("13:13").Insert Shift:=xlDown

Mike
 
D

Don Guillett

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
 
Top