Code Works only in Debug Mode, Not When Button is Clicked.

**shaht96** · 07-17-2018, 01:14 PM

Here is the code below. It works perfectly when I step into the sub routine and continually hit F8 but not when the button is hit in the excel sheet.

PHP Code:


Sub ClearFilter_Click()

  Dim route As Object
  Dim total, routecount, x As Integer
  total = 0
  For Each route In ActiveSheet.Range("AU1: AU350")
  ActiveSheet.Range("D1").Clear
  x = route.Value
  ActiveSheet.Range("D1").Value = x
  Data.Range("OutOfSequence[[#All],[WaveNumber]:[Out of Order?]]").AdvancedFilter Action:=xlFilterInPlace, CriteriaRange:=Data.Range _
("AO1:BZ2"), Unique:=False

routecount = Application.WorksheetFunction.CountIf(Range("OutOfSequence[Out of Order?]"), "YES")

total = total + routecount
ActiveSheet.Range("D7") = total
  Next route
  ActiveSheet.Range("D7") = total
  

End Sub

**Norie** · 07-17-2018, 01:57 PM

How does it not work when you click the button?

**shaht96** · 07-17-2018, 02:08 PM

It does not display the value as it should. When I debug it, and step into every time is calculates and displays as it is supposed to. When I click the button attached to the macro, it just says calculating and does not produce any results.

**Richard Buttrey** · 07-17-2018, 02:22 PM

Originally Posted by shaht96

It does not display the value as it should. When I debug it, and step into every time is calculates and displays as it is supposed to.

It would help if we could see the workbook. You don't say what the value should be, nor what value you are getting.

Are you sure the button is on the same sheet that you are analysing with the code. It's all to easy to have a sheet active when you step through code so that you can flip back and forth to check things. But if the button is not on the sheet in question and since you don't qualify the range "AU1: AU350" with a specific sheet name - just ActiveSheet then you will get inexpected results.

**shaht96** · 07-17-2018, 02:49 PM

Unfortunately my workbook is too large to upload

**Richard Buttrey** · 07-17-2018, 03:30 PM

We don't need the full size workbook. Take a copy and delete most of the data leaving just enough to replicate the problem then upload the copy.

**romperstomper** · 07-17-2018, 05:11 PM

What is the point of the filtering in the code?

Code Works only in Debug Mode, Not When Button is Clicked.

LinkBack

Thread Tools

Rate This Thread

Display

Code Works only in Debug Mode, Not When Button is Clicked.

Re: Code Works only in Debug Mode, Not When Button is Clicked.

Re: Code Works only in Debug Mode, Not When Button is Clicked.

Re: Code Works only in Debug Mode, Not When Button is Clicked.

Re: Code Works only in Debug Mode, Not When Button is Clicked.

Re: Code Works only in Debug Mode, Not When Button is Clicked.

Re: Code Works only in Debug Mode, Not When Button is Clicked.

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] MAcro works OK in Step into debug mode but not doing job when run from command button

[SOLVED] VBA code works in debug mode but misses steps running in normal mode

VBA Code Runs in Debug Mode But Returns Type Mismatch Error Outside Debug Mode

[SOLVED] Code skips on Run Mode but runs fine on F8 (Debug Mode)

VBA code only works correctly in Debug mode

[SOLVED] Macro Works but not in Debug Step mode

[SOLVED] [SOLVED] Excel 2000 Code works except in debug mode

Bookmarks

Bookmarks

Posting Permissions