Inserting cell with shift right and Copy format in multiple specified sheets

I'm trying to insert a cell at C3 & C4 across three named sheets and also wanted to apply the format from existing C3:C4 to the inserted cells.

My current code will add the cells to columns C to E on sheet "Budget Template" only and not copy format.

What code will loop through all three sheets and insert the 1 cell with copied format?

Thanks

Please Login or Register  to view this content.

Please Login or Register  to view this content.

thanks

I tried the code you provided which helped to copy the format across but I still need to insert cells before copying the format

using your code I came up with following which inserts cells at C3:C4 on sheet "Budget Template" but does not work for "CEM" or "BIM" (the format does seem to copy at C£;C4 on all 3 sheets though).

Any advice on how to amend code to insert cells at at C3:C4 on all 3 sheets "Budget Template", "CEM" and BIM would be much appreciated

Please Login or Register  to view this content.

in fact there is an easier way to explain what I am trying to do.

How can I make the following code more efficient so that lines are not repeated. The string "Card" in sheet name is unique to the sheets I want to be changed by the code:

Please Login or Register  to view this content.

thanks

Originally Posted by wingbot

... but I still need to insert cells before copying the format ...

Prepare a file with sample data.