View Single Post
  #3   Report Post  
Jason Morin
 
Posts: n/a
Default

Right-click on the worksheet tab, View Code, and insert
the code below. Press ALT+Q to active XL:

Sub Worksheet_Calculate()
With Range("B1")
..Value = .Offset(0, -1).Value
End With
End Sub

---
B1 will equal the value of A1 whenever the sheet is
recalc'ed.

HTH
Jason
Atlanta, GA


-----Original Message-----
I have a a cell containing a formula to display a total

time.

e.g. A1 contains =SUMIF($E$5:$E$25,$E28,$D$5:$D$25).

This is my actual
formula. The answer it gives is 01:00 in time format.

Is it possible to display the answer to the formula in

cell B1 but not to
contain the formula. B1 needs to change as A1 does.
.