run-time error '1004'

Hello All, The code below yields run-time error 1004 on the lines for AH15 and AH44, but works fine for AH19 and AH48. The only change to the formulas in AH15 and AH44 was "-R[-5]C[-20]-R[-5]C[-19]-R[-5]C[-11]" replaced "-R[-5]C[-21]-R[-5]C[-12]". The macro uses an input box for the week number...

Hey all, I think i'm missing something super simple here but yet can't spot it. I have a simple macro that opens another file and runs a macro within that file. It worked the very first time and then stopped running. It gives a Run-Time 1004 error on Application.Run line "Cannot run the macro...

I think the code is fairly self-explanatory, but I'm trying to search for a number (VehNum) in a column (VehCol) and copy all of the rows with the same number in the that column to a new sheet. I'm receiving a "Run-time error 1004: Application-defined or object-defined error" in 14th line of...

I am getting the subject mentioned error while processing the following code: Public Function CheckIRR1(Company As String, Term As Integer, Premium As Integer, ProposalDate As Date, YearlyInstalment As Integer, DateOfLastPayment As Date, DateOfMaturity As Date) Dim nArraySize As Integer...

I have some VBA code that someone helped me with years ago that works great 99% of the time. For some reason, When I try to delete one cell from all the spreadsheets within the workbook at once - or do a replace all on a highlighted group of cells (again - on all spreadsheets at once) I get the...

Hi Hope you can help with this pesky VBA problem! I don't know how to use VBA but I was sent a spreadsheet to update employee notes There's an input console to type in the data but every time I choose anything with a validation list I get the message: "Run-time error '1004': Method 'Range'...

I have this large macro that when it is contained as one large macro the code runs perfectly without issue. Sub RSLDashboardtesting() Dim APPSPD As Worksheet With Application .ScreenUpdating = False .Calculation = xlCalculationManual .DisplayAlerts = False...

I am teaching myself VB using ms Excel 2010. I am trying to search through 7000+ rows of data for certain keywords, and then pasting these rows to another sheet. I have the code to where it works when I step through line by line with F8, but when I actually run the code I get "Run-time error...

Hello, I am trying to code the following: I have supplier names in Column A, and I am searching by the name of the supplier by using the match command, which provides the Row value of the searched name. Then I would like to delete the supplier that has been found in the array. So I am using...

I use this code to retrieve historical stock prices for about 40 tickers. I found it here http://www.mathfinance.cn/download-multiple-stock-quotes-from-yahoo-finance It downloads about half of the symbols before a Run-time Error '1004' pops up. "Unable to open...

Hello all, Merry Christmas and Happy New years! I am having an issue with VBA Scripting. This is what I've done: Sub Create_Dynamic_Forecast() ' ' Create_Dynamic_Forecast Application.ScreenUpdating = True 'ActiveWorkbook.Save Sheets.Add After:=Sheets(Sheets.Count) ActiveSheet.Name = "Dynamic...

Help, i'm in troubles when trying to refresh a query table. I never have this problem, but I'm using Excel 2010 file type XLSM Sometimes works perfect, sometimes is failing, very erratic, however : Private Sub btnClearFilters_Click() Range("B1").Value = "" Range("B2").Value = "" Dim strSql...

Hi There, I am having an issue with this Macro, basically it will work to a degree but then start to fail for some reason. I have checked some other posts relating to this and have made sure that the AutoFilter is off, and that seems to be along the right tracks but I will start getting the...

Hi, After spending the past seven and a half hours trying to get this to work I have admitted defeat. What I'm attempting to do is copy 27 worksheets, names set in a range "nao_sheets", paste them in to the same workbook in any position (although a new workbook would also be fine) and then...

I have what I thought was a simple macro, to transfer a range of cells from one worksheet to the next available row on another worksheet: Private Sub CommandButton2_Click() ' Save & Print button Sheets("TOOL").Range("BA132:EX132").Copy Sheets("Data").Activate Range("A65536").Select...

Dear VB-experts, I have 5 worksheets that are updated regularly in a folder and then brought into a new summary workbook using vb code. This works all fine. My problem is when I try to merge the 5 sheets to one summary sheet in the summary workbook using vb code. Code: Sub Step_5() Dim ws...

I've been using a financial analysis program, LseMod, for many years with xp sp(3) and excel 2003. I just bought a new computer with windows 7 and excel 7, and now the program won't work and starts with the error message "Run-time error '1004': Unable to get the DrawingObjects property of the...