error 400

  1. K

    Macro-assigned button causes error

    I have a code that generates two new sheets based off of templates every time that it runs. I have a button that the macro is assigned to. When I click the button, it generates the first of the two sheets and then gives me an error 400 message. I go back, delete the sheet that was generated, and...
  2. D

    Entirerow.delete Rows function Error 400 problem

    Hi guys, I made this command, before it was working fine. I have been using it for quite sometime now. Sheets("DATABASE").Rows("4:1048576").Delete Now suddenly there is an error showing, I didn't change anything to my programming. Error 400. Tried this too in hope that it will get fixed...
  3. S

    VBA code fails on SaveAs when .xltm

    Morning everyone!!, This is my first post here. I normally stay back and figure things out on my own but this one has me stumped. Any help or insight that you might be able to provide is greatly appreciated!! I have some VBA code that I use to save a workbook. It is linked to a button for ease...
  4. M

    Error 400 on copy and paste VBa code

    I am trying to run a copy and paste code for a much larger marco that has a repeated copy and paste code. I get the 400 error with the lines of code idicated in bold (i have sepereately gone through lines checking!). Any and all help muhc appreicated! Sub copy() Dim TestRange As Range Dim...
  5. J

    Excel VBA 400 error

    Hi all, I have a macro that is trying to copy rows over from one workbook to another based on whether the values in column AR (column 44) are not equal to 0. However, I'm getting an "error 400" every time i try to run it, without direction to which line is causing the error. Does anyone have...
  6. V

    Getting a 400 error when I try to run a macro that worked yesterday

    I am trying to write a macro that automatically saves a copy of the spreadsheet and then attaches it to an email in preparation for sending it to the vendor. The thing is, the macro worked perfectly yesterday and now today, the macro returns error 400 when I try to run it from the spreadsheet...
  7. L

    Error 400 (1004?) Saving in VBA

    Good day! I an not really a coder, but somewhat of a power user. I hope to be able to accomplish some fancy coding with a little help from generous geniuses like yourselves. I'm coding a macro in VBA to save a copy of the Active Workbook with a new name based on some variables within the...
  8. A

    Error 400 using next invoice - podcast 1505

    Hi, I have Excel 2010, and I'm getting an error message when I press the Clear and save button while using my invoice on my computer the error that i get is 400 i want the macro to save the invoice as (for example) invoice # 31254 and once it saves i want it to close automaticalluy the...
  9. F

    Autofilter VBA Question

    Hello I am using the following code below to autofilter the whole sheet, and have the column C with value of 1 for which rows I want to autofilter from VB. The problem is I have a couple cells that I have been told have to be protected. When I protect the sheet with only those cells locked...
  10. V

    Error 400 Appears and Then Goes Away On Its Own

    Hi all! I'm really hoping that someone will be able to help me out with my dilemma. I've built a spreadsheet that draws a cross-section and then calculates a bunch of properties based on it's dimensions. In a nutshell, you enter in the dimensions, select the cross-section type (three to...
  11. J

    When I run the code I get a VBA 400 error

    The code performs the match and selects the data on sheet1. The msgbox I inserted shows the correct column on sheet2, then I get the 400 error. Is the problem in the Cells(2, i).Select statement. I am stumped. Any thoughts? Sub temp() Dim i As Integer i = 1 Do While Not...
  12. S

    Macro / Toolbar Issue Error 400

    I use excel so much, that in excel 2003, I had created macros, all they did was open a particular file, and then i created custom toolbar buttons, so that for each file that I used often, I had a toolbar button that if clicked, would open a file. when I started using 2007, on the addin tab, my...

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