breakpoint

I have some code that copies the contents of a table on one sheet and pastes the values into another sheet. This is part of a longer process that opens an external workbook, copies its contents into a tab in the main workbook, the updates a table via refreshing a query. This part all works...

All, Apologies ahead of time for the ugly code. I am a complete novice at this and have used inputs for forums like yourself to kludge together something that appears to work, except that I can't get it to run successfully when I push play. I've seen a lot of posts about only working when...

Here's a debug screenshot: http://i.imgur.com/HT3mFXy.png?1 The error (Application-defined or object-defined error) occurs at the highlighted breakpoint. This code works for every instance before this, but breaks at i = 34640 and check = 5519. The cells are both valid, and they're listed in...

Hello guys and gals. I got this weird situation that I hope someone can help me resolve. I have tried a lot of googling, but am unable to find a solution. The web is flooded with people not understanding Application.EnableEvents, so it is a bit difficult to find relevant information. I can...

here's the macro: Windows("WB1.xlsm").Activate Range("A1").Select Range(Selection, ActiveCell.SpecialCells(xlLastCell)).Select Range(Selection, Selection.End(xlUp)).Select Selection.Copy Workbooks.Open Filename:= _ "WB2.xlsm" ' ActiveWindow.ScrollWorkbookTabs...

When diagnosing my code I want to put in a lot of stops but that can get frustrating after a while. Is there a way to disable the stops/Break Points?

I have an excel macro. When I run the macro without a breakpoint, the spreadsheet calculates slightly different values than when I run it with the breakpoint. Unfortunately, when the macro is run with the breakpoint, I get the correct values. Any ideas on what is happening? Mike