how to copy and paste the value, not the formulaic definition

[Elaine Jackson]

Hi. Here's the situation:

I have a worksheet that's divided into two regions: the first regions has a
bunch of cells with boolean values (TRUE or FALSE) in them; the second region
also has a bunch of cells with boolean values, but the difference is that the
values in the first region are just constants, whereas the values in the second
region are defined formulaically in terms of some of the cells in the first
region. Are you with me so far? I may be saying this wrong because I'm not
familiar with Excel terminology. An example: maybe the first region contains
cells A1 and A2, both with value TRUE, while B1 belongs to the second region and
is defined formulaically as AND(A1,A2). In that case B1 would have the value
TRUE also, the difference being that the values in A1 and A2 are not defined in
terms of anything else. OK, so now here comes the question: How can I copy and
paste the value of a cell in the second region, leaving the formulaic definition
still sitting there associated with that cell? Ideally I would like to be able
to do this operation on an entire row of cells at the same time. Any help with
this problem will be greatly appreciated. Feel free to explain in Visual Basic
or pseudocode if it helps.

 

[Anders Silven]

Hi Elaine,

Not sure I understand, but here are two ideas using Paste Special

1. Copy B1, select C1 and do Edit>Paste Special>Values
This will enter just the value of B1 in C1, TRUE or FALSE, in C1.

2. Copy B1, select C1 and do Edit>Paste Special>Paste Link
This will create a link to B1 in C1, so when B1 changes, C1 will also change.

This also works with a range of cells.

HTH
Anders Silven