Thread: [Solved] Macro will not read the value of cell with a formula in it!
View Single Post
 
Old 03-28-2015, 01:11 PM
charlesdh charlesdh is offline Windows 7 32bit Office 2010 32bit
Expert
  
Join Date: Apr 2014
Location: Mississippi
Posts: 382
charlesdh is on a distinguished road
Default
Hi,


Your reference to "Calculate" you may try something along this order.

Code:
Private Sub Worksheet_Calculate()
Static oldval
If Range("C1").Value <> oldval Then
    oldval = Range("C1").Value
    '
    'rest of your code here
    '
End If
End Sub
Reply With Quote