Format cells in multiple sheets automatically

[gokica]

Hello!

I have a spreadsheet that has multiple sheets. It is generated by a software. The names and the number of the sheets varies each time.

I am kindly asking for help with a macro that will do the following in each sheet of the file:

1. Cells D3-F3: add "Thick Bottom Border";
2. Cells E6-H6: merge and center and add "bottom border" (not thick but normal).
3. Cell D9: format as date (dd/mm/yyyy)

Attached please find the example file showing how it is and how I need it to be. The cells that require adjustments are highlighted for easy spotting.

Your efforts and time dedicated to resolving this issue are mostly appreciated.

[JOHN H. DAVIS]

Maybe:

Please Login or Register  to view this content.

[MarvinP]

Hi gokica,

If you turn on the macro recorder and simply do what you ask you will get the following in the attached. Go to any sheet and run the macro. See if it works for you.

[gokica]

Maybe:

Please Login or Register  to view this content.

Wonderful! Thank you so much. It works.

I just need to add the Centering of the merged range E6:H6 and also I will add Thick bottom border at cell D9. But I will try to do this my self.

Thank you so much.

Hi gokica,

If you turn on the macro recorder and simply do what you ask you will get the following in the attached. Go to any sheet and run the macro. See if it works for you.

Thank you. The problem is that there are over 200 sheets in the file and if I run the macro on each sheet individually it will take a lot of time. I was aware of the macro recorder but I could not figure out how the same routine can be applied automatically to as many worksheets as there are in the file.

[JOHN H. DAVIS]

You're welcome. Glad to help out and thanks for the feedback.