Preserving attributes for pasted objects 1

[Lowlevel32767]

When I copy and paste a linked cell in Excel, is there any way of preserving the format?

i.e. If I change the colour or size of the original item, can I get the linked cell to change too? [Seacaptain]Arrr!.. I don't know what I'm doing[/Seacaptain]

 

[xlbo]

sorry but AFAIK - no
Not sure you could even do this via code as changing formatting doesn't launch the worksheet_change event
Rgds
Geoff

Si hoc legere scis, nimis eruditionis habes

 

[Lowlevel32767]

Thanks for that... not the answer I wanted... But I suppose that's 'Uncle Bill's' fault not yours...

MSOffice - the non-visual solution for the Visual world [Seacaptain]Arrr!.. I don't know what I'm doing[/Seacaptain]