Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Check to see if a formula is correct
I want to do something like this
Sub Macro1() If Range("A1") =(=B1 + B2) Then ' This is a formula Exit Sub Else Range("C1").Select 'Has correct formula Selection.Copy Range("A1").Select Selection.PasteSpecial Paste:=xlFormulas End If End Sub How do I do this? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dup check 2 columns - need it to delete correct one | Excel Worksheet Functions | |||
Need to check if the value in one cell is correct or not | Excel Programming | |||
Check inputbox enter is in correct format | Excel Programming | |||
What's the correct format to check the name of a sheet? | Excel Programming | |||
How to correct this formula and check if more issues are existing? | Excel Programming |