1004

I keep getting a Runtime Error 1004 with a particular macro. The debug option always take me back to the "UsedRange" portion of: If ws2.Range("A:A" & Rows.Count).End(xlUp).Row > 4 Then ws2.UsedRange.Offset(4).Clear What's so frustrating is that if I copy and paste the contents to a brand new...

Hi all, I am totally new to VBA, its my first code. I wanted to create macro which could insert a row after finding different value. I managed to write something like this. Could you pleas check what is causing the error 1004 - Application defined or object-defined error? Sub InsertRow() Dim...

I receive an automated report and use it to update an internal file for my department. All columns are formatted almost identically between the two sheets (at least for the two criteria I am working with). My goal is to have a macro that will update our internal file to match the information...

Hi team, Code below. I t is meant to run through the work book and format the Tab name with the name in D6. It has been working fine for a couple months but now it refuses to budge from this error on this line. There are on 10 names that appear repeatedly. Sub Tab_name() Dim ws As Worksheet...

Hi, I have 2 sets of code. One copies the form and the second pastes it. (the ancillary functions are sheet hide unhide etc) The problem is, at times the codes work perfectly fine. But sometimes i get the "pastespecial method of range class failed 1004" error. I have created an excel ribbon...

Hi MrExcel Forum, First time poster (to any forums), was wondering if anyone can help me with this tiny bit of code on here. I see similar issues posted to the forums but nobody says what the underlying cause is so I'm not sure how to fix my particular situation. What I want it to do: Go...

I am a complete noob to VBA. We have a macro that runs fine on Excel 2013 but gets a Run-time error on 2016. The part of the macro where it hangs up is trying to copy and paste merged cells. The error states "To do this, all merged cells need to be the same size." They are the same size. It...

I'm having some VBA problems. I've used the below code many times before on other workbook (just changing the specific parameters for each sheet)without any problem. However now I'm begging the "Run-time error '1004' Application-defined or object-defined error" error for the "East Mezz Input"...

So I have a very large worksheets(400000 + in length 8 variables) that have the price for a stock and i want to organize it into a worksheet where all cells are side by side. I trouble shooted through until I got it to work for about half of the data set until it said overflow error. I check to...

Hello guys, I have an macro I am fighting last 5 days with no luck. I am doing FOR loop every row filled and hidding shapes (pictures) based on value in Column C in every row. So far I am only in stage that I wish to FOR loop of all shapes and hide or show (just to test that everything works...

Appreciate help with understanding how a VBA macro that works fine in Excel 2010 and 2013, but that generates an error (Run-time error '1004': Application-defined or object-defined error) when executing in version 2016 explicitly. The macro is embedded with a sheet in a workbook (the "Index"...

Im trying to do something like this "om" is the if formula but in my language Range("f3").Value = "=OM(+'1'!H3=0;"";+'1'!H3)" and for some reason i get the 1004 application or object defined error when i do this the first line of code works but the same error appers on the next line, why...

I have a macro that splits an Excel workbook into separate files and generates an email to the respective recipients for each file. I have a sub for each individual file created. I used to not have issues, but just recently received an error after the first sub successfully ran and sent an...

Hi guys I've been stuck with this problem for a while now and was hoping one of you could help out :). The problem code is shown below and is being run from a word document which reads an excel file (myWB - opened with a GetObject call). With...

Good morning, I am attempting to sort a table of data, specify via the table filter function any numbers less than 2, select all rows of data meeting this criteria via special go to (visible cells only), paste these rows into a new sheet, and then delete the resulting empty rows. Unfortunately...

Hello all, I've been trying to figure this out for a while now (I hope it is right in front of my face and I just can't see it). I have a line of code that works when it is ran in its sub, but throws an error when that sub is called upon. I get a "Run-time error '1004': Application-defined...

Greetings wise ones I have been burdened with glorious purpose by my boss, to create an excell file that auto-imports a big ol' list of tables from our sharepoint database, every time the document is opened - mainly to use it as an auto-generating list which is then to be saved into a new file...

Dear all, this is my first post here and I have been using vba only for a month, so sorry for any naïve question. In my excel sheet I have a button which is connected to a macro which copies data from another workbook to the row of the button. The code is here below. I need to get the row...

I'm trying to write a macro to pull up a webpage with a tracking number, return the delivered date, then move to the next tracking code to do the same. I want that to continue down the spreadsheet until there are no more tracking numbers. This can't start at a particular cell every time because...

The VBA below was created by recording a macro that applies AutoFilter to Column A, filters Column A for all rows containing the string “C U S T O M E R L I S T”, and then deletes all of those identified rows. This code executes successfully in Excel 2010 and 2013, but is generating the...