400 error

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...

Hi there, So happy I found this forum of experts. Hopefully someone can help diagnose this error. Sub TransactionIndex() 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. Sub InsertFormulas() Dim lrow As Long lrow =...

Hi, 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. Code: 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"...

Hello All, 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

Hi, 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...