400 error

  1. A

    Error 400 in VBA to copy data between workbooks

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

    Error 1004 when saving copied worksheets as new workbook

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

    Error 400 (1004 in Debug)

    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 =...
  4. K

    400 Error on Button Press Before Sub-Procedure Runs

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

    Macro Runs only from VBA Editor. Returns 400 Error when attempt to run from Excel.

    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 =...
  6. T

    Open a workbook and copy the first sheet into a defined sheet in excel vba

    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()...
  7. L

    Macro stopped working, but works when I step through it

    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"...
  8. A

    using XML in VBA

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

    400 Error / Run Time Error 1004

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

Some videos you may like

This Week's Hot Topics

  • Launch Script When Tab Is Opened
    Hello all! Is there a way to launch a script or message every time a particular tab (DATA1) is selected/opened? I know it can be done when...
  • VBA that can extract words that starts with # and ends with 2021.
    Hi Everyone, I am straggling to in searching for a vba code that will extract a string that starts with # and ends with 2021. The string has no...
  • Date update overflow error ‘6’
    Dear MrExcel community, I have a project search & update & add & delete can do. There are 32 column and 5 of them is date. When I search date...
  • VLOOKUP Formula ?
    Hi i am using this below but i need to return Column C on Detailed_view. You can see ,1 this returns D, but i need to return C before D. I tried...
  • conditional formatting the whole row
    Hello This is a question solved earlier by etaf. But I am getting some problem. I need help to correct the formula as it is not working in some...
  • Vlookup in vba
    Hi, I am new with the VBA, can someone help me, I have made this macro, but the loop across files in a directory runs only in cell G13, and I...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back