View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
ZZBC
 
Posts: n/a
Default How can I test if a Macro if firing?

I was given this code from another post "How do I convert a cell(s) from
the formula to it's contents?" .

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column < 1 Then Exit Sub
With Sheets("Output_5Tab")
.Range(Target.Address).Value = Target.Value
End With
End Sub

When I change in my input sheet "Int_5Tab" I get no indication that
anything is happening in the output file "Output_5Tab"???
Any recommendations ?