How can I make reference to WHOLE cell, including cell formation

[Sirritys]

Hi,

I was wondering how how can I make reference to whole cell.

When I write ie. =B2 to A1 it only brings the value of B2 to A1.

So how can I make same thing but also get the "cell format" from B2 to
A1?


Thanks for help,
Aki Koikkalainen

 

[Alan]

You can't transfer the cell format by using =B2, it will only return the
value in A1. It could be done I suppose with VB code, but unless there's
some vital reason for doing so it's probably not worth the trouble,
Regards,
Alan.

 

[Sirritys]

Why would I use reference if copy/paste would be acceptable solution ?
=)

I need other sheet to update it's info as I type or modify cells at
other sheet.

Doesn't anyone have solution for this problem ?

Yours,
Sirri

 

[Dave Peterson]

There is no solution if you're going to use a formula.

But maybe you could use a worksheet event macro to do the copy|paste.