HELP with VBA code Please :(

[usui]

Hi excel masters,

I hope you can help make create a code that can help resolve my problem. I'm using excel 2016 and we already have a added macro that auto hides the row 1 & 2. Please see the sample picture below.

what I'm hoping to make is to add a new macro that will auto unhide the Row 2, that will merge the Row 2A until the last column used with a background color of yellow with a note in the middle of it with a Font style (Calibri), BOLD, font size (14). Please see the sample picture below.

I hope you have a vba code that can make this possible to achieve, I really need this for my work

I hope someone can help me and thank you in advance masters.

 

[silentwolf]

Hi,
I am not sure why you not recording a macro to do just that?

 

[Akuini]

that will merge the Row 2A until the last column ....

You should avoid merged cells. Rather than using merged cells, have a look at "centre across selection"
Please check this out:
LINK

 

[usui]

You should avoid merged cells. Rather than using merged cells, have a look at "centre across selection"
Please check this out:
LINK

do you have a vba code that can do the centre across selection?

 

[usui]

Hi,
I am not sure why you not recording a macro to do just that?

i am sorry i dont know how to create a macro, i only know how to add it. that is why i am asking for help here for a vba code

 

[Akuini]

do you have a vba code that can do the centre across selection?

Sorry, I don't have the code for that.

 

[silentwolf]

Hi,

i am sorry i dont know how to create a macro, i only know how to add it. that is why i am asking for help here for a vba code

Well look it up how to record a macro in Excel... that is what you should be your first step going towards VBA .. There are tons of videos on the web
Go and check them out.