run time error 1004

I have a VBA macro for Excel 2007 below that loops through a workbook and deletes a picture (shape) in a range at the top of each worksheet. The macro works fine until a cell which contains a seemingly unrelated data validation list on Sheets(1) is changed. The macro then repeatedly trips up...

I'm trying to understand the problem with the following code: If x = y Then Sheets("Sheet1").Select Cells(row, 1).Select Selection.EntireRow.Copy Sheets("Sheet3").Select Cells(row, 1).Select ActiveCell.PasteSpecial Sheets("Sheet2").Select Cells(RO, 2).Select...

I am getting Method 'SaveAs' of object '_Workbook' failed" error after my macro successfully creates 34 out of 176 files. I realize this is probably a memory issue. I have been searching all morning to see if I can find some code that will get my system to release resources etc. but have not...

Hi,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> <o:p></o:p> I just started using VB to create macros in Excel recently and I could really use some help.<o:p></o:p> <o:p></o:p> This macro is intended to go through a column of identifiers in one...

Hi, I am receiving the above error when trying to process this line of code: FinalRow = 20 Cells(4, 18).Resize(FinalRow - 3, 1).Formula = _...

Hi there, I am using some code (Got from VoG). that deletes errors, but Now I have found that sometime the data will not contain errors. Is there an Error handler I can use to bypass the error so that the Code will continue to run> here is the code that I am currently using. Range("A2").Select...

Hi I am a beginner at VB code and have been playing around by recording small macros to do tasks and then pasting them together and adapting to complete the task. I have created a macro that using an advanced filter will sort the raw data using 8 different parameters and after each filter...

I have an Excel 2000 macro (that runs smoothly on Excel 2000) but that creates a 1004 run time error in Excel 2007 but only if certain conditions are met. Basically it is a text parser that copies certain data to a worksheet "Country" if a certain countrycode is met and sends this worksheet by...

Hi, You guys were so helpful last time, I thought I'd try this again. So I have a form button that runs some macros and when I click it once, all is well and it does what I told it to. If I click it a second time I get the Run Time error 1004 PasteSpecial method of range class failed. So I...

Hi, totally stuck here. So I record a marcos that does what I want (basically take some data from one worksheet and paste (transposing) onto another spreadsheet) and it works - Here it is: Sheets("Paste Sheet Here").Select Range("B4:B8").Select Selection.Copy...

I need to update a large number of workbooks, and do this using VBA. One of the updates is to add data validation to a given cell. I have recorded a macro, which I am then trying to use, but I keep getting a 'Runtime error 1004 Application-defined or object-defined error'. The recorded macro...

Hi Guys, I was hoping you could help a run time 1004 error I am getting on the following code: Sub Test() Dim intNumber As Integer Dim intCount As Integer Dim wkbBook As Workbook Dim varFile As Variant Dim strSheet(1) As String strSheet(0) = "Audit Data" strSheet(1)...