Update a cell

Microsoft Excel 2007
September 15, 2009 at 08:28:09
Specs: Windows XP
How do I update a cell with the results of a formula from another cell. I do not want to place a formula in cell one - just the results from another cell.

See More: Update a cell

Report •


#1
September 15, 2009 at 09:28:27
There are 2 ways to set one cell equal to another cell:

1 - With a formula: e.g. in B1 enter =A1
2 - With a Macro: Range("B1") = Range("A1")

OK, 3 ways...

3 - Type the value into B1 manually.

If you don't like option 1, you'll have to use 2 (or 3).



Report •

#2
September 15, 2009 at 12:55:24
Thanks! Number 2 works for me.

Report •

Related Solutions


Ask Question