bluefeather8989
Active Member
- Joined
- Nov 20, 2009
- Messages
- 331
- Office Version
- 365
- Platform
- Windows
Code:
If C30 = 1 Then
Application.ScreenUpdating = False
Range("C30").Select
Selection.ClearContents
Range("A1").Select
ElseIf C30 = "" Then
Range("C30").Select
ActiveCell.FormulaR1C1 = "1"
Range("A1").Select
Application.ScreenUpdating = True
End If
End Sub
it wont work the way i want it to work
if C30=1 then delete C30. if not then insert 1