Hi,
I am struggling with what I know is a very simple piece of code. I was hoping someone could please help?
I would like excel to run a particular Macro (simple copy past value), if the value (formula) in cell "c3" on sheet "assumptions" is anything other than 0.
I am using the following in the code of the "assumptions" sheet which is not working.
rivate Sub Worksheet_Change(ByVal Target As Range)
If Target.Cells.Count = False Then Exit Sub
If Not Intersect(Target, Range("C4")) Is Nothing Then
Sheets("Assumptions").Select
Range("C202").Select
Selection.Copy
Range("C201").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
End If
Any suggestions?
Thanks
I am struggling with what I know is a very simple piece of code. I was hoping someone could please help?
I would like excel to run a particular Macro (simple copy past value), if the value (formula) in cell "c3" on sheet "assumptions" is anything other than 0.
I am using the following in the code of the "assumptions" sheet which is not working.
rivate Sub Worksheet_Change(ByVal Target As Range)
If Target.Cells.Count = False Then Exit Sub
If Not Intersect(Target, Range("C4")) Is Nothing Then
Sheets("Assumptions").Select
Range("C202").Select
Selection.Copy
Range("C201").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
End If
Any suggestions?
Thanks