1004 run-time error

Hi, I am new to VBA and am experiencing following problem. I have created excel spreadsheet and need to record date record created, who created the record and who modifies the record as per below code Private Sub Worksheet_Change(ByVal Target As Range) Sheets("Additional Charges").Select...

Hello, I know you're probably tired of all the 1004 questions, but i'm just puzzled! The goal of the code is simple: fill all date (pivottables, pivot charts, normal tables, etc), to only show "J1" or "Samsung J1". The odd thing is, i can run this code once, perfectly, and than not anymore (i...

I have been using the following macro to capture 7 pages of a schedule to pdf. It has worked without issue for quite a while, but now returns an error. The error occurs at this point: (PDFranges.ExportAsFixedFormat Type:=xlTypePDF, Filename:=saveFileName, _...

Hello wonderful Excel gurus, I have a bit of VBA code I could use help with. It's fairly straight-forward. Based on two cells, tt looks up a value in another workbook, copies it, closes that workbook, and pastes the value where I want it. However, I'm getting a 1004 error. Here's the code...

I have the following code that i resulting in an error due to it is too complex and not a contiguous set of data. I beleive it is due to there being too many rows for Excel to properly execute. I have scoured the forum to make something work in my favor, but have come up with incorrect...

Hi I'm trying to add an autofilter to a row where the first 3 columns of data are refreshed from an external data source and the next 4 columns of data are formulas (Range A4:G#varies). I can manually add an autofilter to this row outside of VBA, but when I try to use code the subject error...

Hi all, I have quite a bizarre error occurring with the code below - when the button is pressed to run this code I get the Run time error 1004 - Paste special method of range class failed. However if I step through the code no error occurs. The error is occurring at the "paste special" stage...

Hi all: I am getting: when I attempt to run through a module that runs another module within the xlsm. I can run personal.xlsb modules successfully. I've tried about a dozen fixes to no avail. is the specific code in question though I use Application.Run many times throughout. Stumped on...

Hi, I'm fairly new to VBA so please forgive my lack of knowledge! I'm trying to use the Match function but get a run-time error 1004. My code is as follows: Sub CAAnalysis() Worksheets(1).Activate Start1 = Application.WorksheetFunction.Match(0.05, "$A:$A", 1) Debug.Print Start1 End...

<!-- BEGIN TEMPLATE: ad_showthread_firstpost_start --><!-- END TEMPLATE: ad_showthread_firstpost_start -->Here I am getting it: For Each cell In Range(temp(0).Cells(1).Offset(0, 1), Cells.SpecialCells(xlCellTypeLastCell)).SpecialCells(xlCellTypeConstants, 1)

Hi all, I wrote a sub that gets called when I need to copy and paste a chart from Excel 2010 to Powerpoint 2010. The sub gets inputs of (SlideNum, XLSSheetName, ChartName, XPos, YPos) to determine which gets copied and which slide it gets copied to. However, I keep getting run time error 1004...

Hello all, I've got to do a presentation on an excel tool I'm working on, tomorrow. I'm just having this issue with this one macro. All the macro does is check if various cells are empty, if any of them are, it makes a "Hide" tag, if they are all filled it makes a "Next" button appear. The way...

Hi, I'm getting a runtime 1004 error: application or object defined error on the code below Seems to be in relation to "ActiveWorkbook.Connections("Database2").Refresh," Any advice appreciated. Sub Send2Access2() Dim cnn As New ADODB.Connection Dim rst As New ADODB.Recordset Dim...

Hi Everyone, I wrote some script to populate a chart from a user form. It worked in Excel 2003, but we have just recently upgraded to 2010 and I started getting this run-time error. Would appreciate someone looking at the script and providing some assistance. The error occurs after the...

Hi, I just installed WIN7 and OFFICE 2010 and when I run macro I got error like: Run-time error '1004': [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified. do you know which driver in office is missing ???

Below macro works on some PC and on others PC shows the error message (it fails on Activesheet.Paste but when you press F8 it works ok, just won't execute in one go): Run-time error 1004: Paste method of Worksheet class failed offset_Increment = Range("r5")...

Trying to copy rows of product information to new worksheets that are named after the products. Column BE2 has the product names without duplicates. Column U has the products randomly dispersed because items were sold at different times during the year. Hope this makes sense. Option Explicit...

hello, so there's a macro that our client started to develop for us (I realize that sounds a little bit crazy, but forget it) and now I am developing it as they do not want to do it anymore. what macro does is more or less sorting rows in descending order of manufacturing recommendation and...