Show actual values added instead of cell references? (=A1+A4 shows as=10+2 in cell)
 

Is there a way to do this via VBA or formula?

I want to show the values that are added instead of the cell
references. Let's say I want to Add use a cell to calculate
=A1+A4...with A1=10 and A4 = 2, I want the cell result to be 12
however the formula to be =10+2 instead of =A1+A4...is this possible?

Show actual values added instead of cell references? (=A1+A4 shows as =10+2 in cell)
 

See your other thread. Please do no multi-post.

Regards,
Fred

"Naji" wrote in message
...
Is there a way to do this via VBA or formula?

I want to show the values that are added instead of the cell
references. Let's say I want to Add use a cell to calculate
=A1+A4...with A1=10 and A4 = 2, I want the cell result to be 12
however the formula to be =10+2 instead of =A1+A4...is this possible?

Show actual values added instead of cell references? (=A1+A4shows as =10+2 in cell)
 

Which other thread?



On Dec 29, 2:15*pm, "Fred Smith" wrote:
See your other thread. Please do no multi-post.

Regards,
Fred

"Naji" wrote in message

...

Is there a way to do this via VBA or formula?

I want to show the values that are added instead of the cell
references. Let's say I want to Add use a cell to calculate
=A1+A4...with A1=10 and A4 = 2, I want the cell result to be 12
however the formula to be =10+2 instead of =A1+A4...is this possible?

Show actual values added instead of cell references? (=A1+A4 shows as =10+2 in cell)
 

All the other groups you posted to. Now you know why multi-posting doesn't
work. You waste your own time, the time of potential problem solvers and
disperse your responses. You had a much better chance of getting a solution
had you posted to only one group.

Regards,
Fred

"Naji" wrote in message
...
Which other thread?



On Dec 29, 2:15 pm, "Fred Smith" wrote:
See your other thread. Please do no multi-post.

Regards,
Fred

"Naji" wrote in message

...

Is there a way to do this via VBA or formula?

I want to show the values that are added instead of the cell
references. Let's say I want to Add use a cell to calculate
=A1+A4...with A1=10 and A4 = 2, I want the cell result to be 12
however the formula to be =10+2 instead of =A1+A4...is this possible?

Show actual values added instead of cell references? (=A1+A4 shows as =10+2 in cell)
 

....or, at least, cross posted, so that the answer was visible in each group.

--


Gary Keramidas
Excel 2003


"Fred Smith" wrote in message
...
All the other groups you posted to. Now you know why multi-posting doesn't
work. You waste your own time, the time of potential problem solvers and
disperse your responses. You had a much better chance of getting a solution
had you posted to only one group.

Regards,
Fred

"Naji" wrote in message
...
Which other thread?



On Dec 29, 2:15 pm, "Fred Smith" wrote:
See your other thread. Please do no multi-post.

Regards,
Fred

"Naji" wrote in message

...

Is there a way to do this via VBA or formula?

I want to show the values that are added instead of the cell
references. Let's say I want to Add use a cell to calculate
=A1+A4...with A1=10 and A4 = 2, I want the cell result to be 12
however the formula to be =10+2 instead of =A1+A4...is this possible?