All Questions
Tagged with error-handling excel
498
questions
0
votes
0
answers
41
views
VBA ADO transaction detailed error instead of generic
I have a problem with ADO transaction. I would like to catch error that is thrown within db, not generic one.
If I remove transaction and execute command then I am able to get it in VBA using err....
0
votes
1
answer
44
views
My device is unable to open an excel app with xlwings or win32com.client, but I need to refresh an excel file to pull data that is editted earlier
I have a pretty long program that basically edits the first sheet of an Excel file with some data, and then the second sheet of the Excel file does some math and fitting to the data and then the third ...
1
vote
2
answers
68
views
VBA - Check for valid file path not working as expected
I'm working on a macro for work and at the end, trying to save. It's going to be accessible to a group so the place to save the file will not be static. As a workaround, I'm asking the user to specify ...
2
votes
3
answers
128
views
What exactly is the scope of the On Error Resume Next statement?
I tested Microsoft's statement about the scope regarding the On Error Resume Next statement:
An On Error Resume Next statement becomes inactive when another procedure is called, so you should execute ...
0
votes
0
answers
33
views
Excel Autofilter not showing data if a criteria element does not exist in filter [duplicate]
Ive spent days working on this issue and searched many forums for an answer.
I have a table of data which contains 5 columns (Source, Area, message, Incidents, Downtime_Hours):
Data Table
I am trying ...
1
vote
0
answers
30
views
VBA handling weird error related to copying chart
I am working on a macro that copies a chart from each worksheet to a temporary sheet. For some reason, the macro fails when trying to copy the 6th chart, and says
The specified dimension is not valid ...
0
votes
0
answers
32
views
How to keep shell open when running VBA code? [duplicate]
I am trying to debug some code a coworker wrote using VBA. I can't find anything wrong with the VBA, but he does call Shell to run a python script. I want to be able to see what's going on while the ...
0
votes
0
answers
79
views
Run-time error '6': overflow for VBA scripting
I tried to implement this code in VBA but it keeps bumping the error of "Overflow"
Could someone help to check what's wrong with my code?
Thanks.
I tried to debug a few times for the ...
0
votes
2
answers
45
views
Error Handling in Workbook Index For Loop
I am trying to sum indexed values from across several worksheets, and I have a method that works. The issue is error handling. It is common that the Match function returns an error when it cannot find ...
0
votes
1
answer
34
views
VBA Excel : Error showing alert (and stopping code) despite Error handling
i'm writing a code that filters out a table and selects the shown data to copy it elsewhere. If the filter I apply shows nothing in the table and my code tries to select "nothing", the error ...
0
votes
1
answer
46
views
Find and Select cells with specific text in one workbook and copy to another workbook gives Runtime Error 91
I use the "Find" option in VBA to search cells (in workbook wbMain) containing a certain text, after which I copy the value in the next column (via the Offset function) and paste it in the ...
0
votes
1
answer
63
views
CPLEX: CP Optimizer took forever to run with no solution
I run my model in CPLEX using Constraint Programming for quite a long time, but it still has no solution so I have to stop the model.
Is there something wrong with my model? I tried to run the model ...
0
votes
0
answers
70
views
VBA Macro runs fine in my PC but gives me overflow error in Excel with work laptop
Overflow error on the debugger is highlighting this line:
concatenatedValue = IIf(isDateColumn, Format(currentData, "mm/dd/yyyy"), currentData)
Code:
Option Explicit
Sub ...
0
votes
0
answers
36
views
how can i get this box to accept my question? Question - VBA error GOTO challenge [duplicate]
I am trying to use "Error goto" and I think its not difficult.
I am trying to get the 2nd VBA code to...
on error, jump to "Sheets("RISA").Select" if the find within the ...
0
votes
1
answer
50
views
Specific line of code is jumping to a GoTo section without being instructed to
I am writing a VBA to which identifies the last row of the used range on a lead sheet in the active workbook and cycles through a specified array of other sheets to extend all the formulas in the used ...