Formatting new pages using VBA

[paulanderson]

Hi,

When I import a document into Excel its needs a bit of formatting to make it look better I have JAN 19 sheet so I tried to do a macro to copy the format across to the dec 19 sheet but it seems to mess up when I press Ctrl + F which is the macro.

Any Ideas where its gone wrong? I added a few columns etc.. as you can see.