So I am banging my head against a wall because I keep getting the helpful "Error 400" box but obviously its not showing me where my code is failing. What I am essentially trying to do is copy data from one workbook to another by inserting a formula to pull it from one workbook into the other...
I am automating the production of a load of output reports, and was getting a 400 Error when I tried to run. I have now narrowed it down and through the err.description have identified it as a 1004 error "The cell or chart you're trying to change is on a protected sheet. To make a change...
So happy I found this forum of experts. Hopefully someone can help diagnose this error.
Dim Index As Long
Dim Current As Range
Dim Row As Range
Index = 1
Set Current = Worksheets("Test").Range("D2")
Set Row =...
I have a button (Form Control not ActiveX Control) that when pressed, calls a sub procedure inside inside a worksheet module for the worksheet that the button is on.
For whatever reason after opening the workbook the first time I click on the button, it produces a 400 error:
Every time I click...
I have a macro that inserts formulas, fills down, and copies and pastes as value.
It executes perfectly when run form inside the VBA editor.
I receive a 400 error when I try to run from Excel.
Here is the code.
Dim lrow As Long
I am trying to write some code to load a sheet from another excel workbook into excel. But although I can open the file, I get a 400 error and the sheet does not copy.
Application.ScreenUpdating = False
Dim MyFile As String
MyFile = Application.GetOpenFilename()...
I've recently added several new macros, and they are functioning well, but some of my old macros are not working. When I execute the old macros, I get a pop-up window with "Windows Visual Basic for Application" as it's title, and ":crash: 400" as the message; there also are an "OK" and a "Help"...
I am trying to send a SOAP request to a webservice from VBA, But i always get http400/BAD request error.
I tried a lot resolve this issue but it doesnt seem to work at all, not sure what could be wrong,
kindly help me please
I've written a macro which has been working perfectly for all but one user. The original spreadsheets have been in place for around a year however the Macro is new and the final users spreadsheet is new as well.
Whenever i try and run the below for this user only and on any PC i get a...