macro problem when i hide fields how to get around?

[ap1]

Hi,
I am trying to hide 2 columns when i hide it without macro it only selects the 2 columns which i selected but when i run it with macro it selects all the columns and hides everything.
It must be doing it because i have merge fields at the top of the sheet. but why does it not do that outside of macro?

 

[Damon Ostrander]

Hi ap1,

This is just one of many examples of recorded code that does not do the same thing as the manual operations that were recorded. Recording is a handy feature, but occasionally one must actually write the VBA code manually to get it to do what you want. Usually the result of writing the code manually is also much cleaner, more efficient code, as is the case in this instance. You should be able to change your code to (this example just for hiding column D):

Columns(4).Hidden = True

 

[ap1]

Thanks. Appreciate your response.