I instruct VBA to insert a value from a cell (say 1,1) to another one (say 1, 3) using this notation:
This works without problems. However, I would also like to copy cell format (all kinds - font, background colour and pattern, borderlines, etc.) with something like this:
This does not work. How can I do it, please? I'd rather avoid using copy and paste format, as it slows down the programme.
Thanks for help!