error 400

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

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

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

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

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

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

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

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

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

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

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

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