worksheet change

  • Thread starter Thread starter RobcPettit
  • Start date Start date
R

RobcPettit

Private Sub Worksheet_Change(ByVal Target As Range)
If Range("d17").Value > 0 Then
Application.EnableEvents = False
Range("a5:o17").Select
Application.EnableEvents = True
End If
End Sub
Hi Im using the above code which worked a few times the stopped woking,
the select is just a test to see if worksheet change is working. I put
a break point at private sub, but its not getting fired each time
theres a chnge in the worksheet. Any suggestins.
Regards Robert
 
Ignore the post, Im an idiot. Id put a break at range selection. The
stopped running the macro, before it enabled the events. What a
plonker.
Regards Robert
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro converts time entered in column E and F from Indian time to CST( without daylight saving) 1
Simple Copy Paste within Worksheet Change Event 2
paste special in this vba code? 1
Trying to run excel vba code when cell value changes from empty to entered value. 1
Change_Event troubles, no error & no work. 6
Need another eye on this Sub() 8
Worksheet Change Event macro fails intermittently 6
Worksheet_SelectionChange Not Firing 5

Back
Top