runtime

  1. Q

    Macros Runtime Error

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

    Runtime error subscript out of range

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

    Update Ribbon Editbox in runtime

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

    getting runtime error -2147467259 (80004005)

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

    VBA Code Won't Run when I Protect Worksheet

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

    need some features in an excel form and some unexpected error to resolve

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

    Vba runtime error 1004

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

    Runtime Error 1004

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

    VBA - Error in code

    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" &...
  10. A

    Activecell.FormulaR1C1 throws a Runtime Error '1004' in Excel VBA

    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 = _...
  11. T

    Runtime Error with shapes(application.caller)

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

    Runtime Error 424 -- Object Required

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

    Runtime Error 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...
  14. M

    runtime error in odd place

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

    Auto filter macro

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

    CSV Import - Runtime Error 1004

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

    Could not set the rowsource property. Invalid property value.

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

    Runtime 1004: Range class method failed

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

    .formula error

    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 =...
  20. Alan_P

    VBA Runtime Error 5147 - This File Could Not Be Found

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

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top