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

S

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
 
A

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.
 
S

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
 
D

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.
 
Top