new workbook needs to copy formulas and values not just values

[winwall]

Hi guys,

what do i need to change in this code to have the new workbook copy over formulas and formatting, not values. if someone can advise that would be great

Mark

Please Login or Register  to view this content.

[Rioran]

Good time of day, WinWall!

As I see, your code fills new sheet with it's own values to annihilate formulas. I think if you will just replace this row, you may get what you want:

Please Login or Register  to view this content.

[winwall]

i just played with it and replaced the .value with formulas on that row and it worked like a charm.

Mark