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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Sirritys - 09 Jan 2007 19:56 GMT

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

Reply to this Message

Alan - 09 Jan 2007 20:25 GMT

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.

> Hi,
>
[quoted text clipped - 7 lines]
> Thanks for help,
> Aki Koikkalainen

Reply to this Message

Rate this thread: