VBA Macro to customize Right Header

[kimkiko]

Hi!

I have spent the last few days trying to make a macro in vba to customize the right header, in a excel sheet with multiple pages, but without much success. :-(

I need some help to do the following macro:

"In first right header page": N. M001 a M002
"In second right header page": N. M003 a M004
"In third right header page": N. M005 a M006
"In fourth right header page": N. M007 a M008
"In fifth right header page": N. M009 a M010
"In sixth right header page": N. M011 a M012
"In seventh right header page": N. M013 a M014
"In eighth right header page": N. M015 a M016
...
...
...
to the last page


Thanks in advance