|
|
#7
03-28-2015, 01:11 PM
|
|||
|
|||
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
|
| Tags |
| macro |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Read cell from one table into another
|
donaldadams1951 | Word VBA | 2 | 02-04-2015 06:46 PM |
| Macro to copy formula from one cell to another | anwar | Excel Programming | 1 | 04-25-2014 08:27 PM |
|
Formula in cell b1 using cell a1 if a1 is over certain number
|
pumkinbug87 | Excel | 5 | 12-03-2013 12:34 PM |
| Change formula cell range based on cell value | Scoth | Excel | 4 | 10-25-2012 07:51 AM |
| how to read R1C1 formula | Suhanti | Excel | 2 | 10-16-2010 11:30 AM |
Windows 7 32bit 
Office 2010 32bit
Threaded Mode