debug

I have a vba macro attached to a worksheet. When I enter debug mode, F8 will not start stepping into the macro. Nothing happens at all. Probably something easy but I cant figure it out. Thanks in advance.

Hi I wrote some code with significant help from forum members about 5 months back. It worked great, but I've had to change the sheet since and now the code is throwing up the error message 'duplicate declaration in current scope' when I run it. The original code would make entries on different...

I have a file server which is home to the back end db. Each user has a copy of the front end and those copies live on a terminal server in this folder structure [SharedUsers] [User A] [User B] [User ...] [User R] The application is used to record notes about client contact events. eg...

My work was kind enough to give me excel 2010 when my old computer died and it is annoying me as the debugging of VBA is atrocious compared to the 2000 version. It seems that whenever a macro has an error rather than the debugging function popping up excel just decides it needs to close...

I am creating a button in excel to hide any rows that are missing data in the first column. I've got the code worked out I believe, but I can't make the button work. The code is as followed: Sub Button74_Click() For Each r In Range("A10:A164") If r.Value = "True" Then...

Hello, I'm new at VBA and I could use some help debugging my code. I keep getting the error, "run-time error '13' type mismatch." Thanks. ' Converts 0.00 values to "-" characters '--------------------------------------- For Each c In...

I had everything working on an Excel 2003 machine, then I tested on a '97 machines and had some bugs. In trying to correct them (unsuccessfully) i have caused some issues with it running in 2003. Some of the machines running at my work are '97, some XP(2002), some 2003, and some 2007. I need...

I have a protected sheet that contains calender controls based on code from Ron de Bruin http://www.rondebruin.nl/calendar.htm (pasted below). The sheet is primarily a reference, but may be edited on occasion. To enable the calender, the sheet must be unprotected, but if an attempt to enter a...

I am using XL2007 and have a macro that refreshes microsoft query connections. The issue is the refreshes only happen if you step through the macro using the debugger. When you run the macro normally, everything else functions properly, but the data is not refreshed. Any help is...

Morning All, I have a procedure that was working perfectly yesterday. I've not changed it and yet today it doesn't seem to be working. I keep getting a 'Runtime Error '13', Type Mismatch' debug error. Can you help? Public intRowCount As Integer Sub mcrCopyDataNewSheet() Dim...

Hi, I am not a genius on VBA and I have only recently started teaching myself a thing or two about it. Basically what I needed to do was apply more than 3 conditional formats to a range of cells. I have drop down cells that represent the "Status" for Projects that I am working on.. I have 5...

Thanks to everyone who helped my on my last question. This time my macro keeps getting held up when I get to Selection.Sort: ActiveWindow.SmallScroll ToRight:=11 ActiveCell.Offset(0, 16).Columns("A:E").EntireColumn.Select Application.CutCopyMode = False Selection.Delete...