runtime

Hi, I have been trying to run macros from my source file to run on my target file. I even selected use "relative reference", however every time I start to work on my file it gives me a runtime error code 1004. I understand that is because it cannot source the reference data. When I debug, it...

Greetings, I am running a chunk of code that uses a loop. Dim A As WorksheetDim B As String For Each A In Sheets(Array("sheet1", "sheet2")) B = A.Name I am receiving the error in the title on the For Each loop line. Is the For Each loop structured correctly, or might I just have an...

Hi Is there a simpleway to update my Ribbon Editboxes from cell updates during runtime. I can seesimple ways to populate editbox when opening a Workbook, and updating a cellfrom the Ribbon Editbox during runtime. I cannot see a way to update the ribboneditbox on cell change? All...

Hey yall i keep getting the runtime error mentioned + Method "document" of object "IWebBrowser 2" failed. My code is pasted below this is a internal site so you wont be able to access it Sub Assetgrabber() Dim IE As Object Set IE = CreateObject("InternetExplorer.Application") IE.Navigate...

Hello, I am sure this is an easy question but would anyone know why I am getting a 1004 Runtime Error in my Code after I protected the Worksheets from the review Tab? The code works fine when the sheets are unprotected, but I need to protect the worksheets so users can not adjust the formulas...

Hi Team, I have created an onboarding form for employees and there is a worksheet where the data is getting stored. The problem is now there is a runtime error coming in a listbox click function where all the records are displayed from the datasheet so in case of any modification user dont...

I am copying a worksheet in one workbook to another with this macro: Sub MoveSheets() Workbooks.Open Filename:="Combined.xlsm" Workbooks("Combined.xlsm").Sheets("NewData").Copy After:=Workbooks("Management Fees 2018.xlsm").Sheets("Inputs") Workbooks("Combined.xlsm").Close savechanges:=False End...

Hello all I am getting an error on the code below highlited Bold Runtime Error 1004 "This selection isn't valid. Make sure the copy and paste area's don't overlap unless they are the same size and shape" I am copying an active Row but then Transposing to column "B1" I know the issue is copy...

Hello, can anyone spot the obvious error in this code that is the reason for it not running please? Private Sub Worksheet_Calculate() Sheets("Data").Range("C" & Sheets("Data").Range("AD2")).AutoFill Destination:=Range("C" & Sheets("Data").Range("AD2") & ":C" &...

This formula was written while recording a Macro. Works perfectly fine in a cell , but when trying to run from VBE ,its throwing a runtime error '1004'. Any help appreciated .... Thanks in Advance Sub Macro7() ' ' Macro7 Macro ' ' ActiveCell.FormulaR1C1 = _...

Dear Users, 1. I have a dynamic list of organisations. Through VBA I insert a rectangle as shapes. Set s = Worksheets("Tabelle1").Shapes.Addshape(62, 70, 120 150, 30) Simultaneously I assigned the created shape a macro through s.OnAction ="Macro" 2. Later this macro should plot data...

I have the following code through which I am passing the address of the selected cell to WkRNG variable. Now, when I click a cell and press okay all goes fine. But, if I press ESC (without any input), I get the runtime 424 error. Dim WkSht As Worksheet, WkRNG As Range, rCell As Range...

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

This part of my macro stops at line 6 below, where it throws up a runtime error... There is no reason why it wont work as its an exact cope of line 2, but references the next column in a spreadsheet nd is for n additional series.. any ideas? ActiveChart.SeriesCollection.NewSeries...

Hi all I ave used this code for auto filter↓, Sub Autofilter_by_selection() Range(ActiveCell.CurrentRegion.Address).AutoFilter Field:=ActiveCell.Column, Criteria1:=ActiveCell.Value End Sub it works in all sheets but the table format it gave me error "runtime error '1004' autofit...

Hi, I have a problem when everytime I run my macro for importing and converting CSV files that I get a Runtime error 1004 saying that it cant find the text file etc. The thing is that if I record a Macro to import the data and copy and paste the path (which is exactly the same as the one I have...

Hi all, I am a newbie in VBA and I need help with the dilemma I have. I have a listbox and a delete button in a frame with named range, lstRates,=OFFSET(ConKiloRates!$A$2,0,0,COUNTA(ConKiloRates!$A:$A) -1,11). My problem is when I delete the last item in the listbox. It displays Runtime...

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

Hi folks, Peter SSs kindly gave me this formula yesterday which works perfectly when insterted to a cell however put into vba i get a runtime error. Am i doing something wrong? is there something missing? this is correct though right? Range("D2").Formula =...

Morning Guys, My attempts at googling this error have been fruitless so any help would be much appreciated! I have an excel sheet that creates word documents and is used by around 5-6 people, but for some reason for only 1 person they get a runtime error 5147 on the line in red below. He has...