runtime

  1. I

    A Runtime Error with an Excel Sheet Operating on VBA

    First of all I acknowledge that I have no knowledge about VBA. I use an Excel Sheet based on VBA. But recently whenever I am going to operate this file Runtime error is coming. I cannot understand how I will attach that excel file ? Without attaching the file it is very difficult to explain the...
  2. L

    Problem with macro excel migrated from one pc to another, error "Invalid procedure call or argument" runtime 5

    My problem is that I import a macro from one PC to another, in my previous PC it worked perfectly and now that I run it on my new PC it does not work, I get an error "Invalid procedure call or argument" runtime 5. Someone who can help me, I do not understand if it is the same code and the...
  3. F

    runtime error 1004 pastespecial method of range class failed

    I keep getting this error "runtime error 1004 pastespecial method of range class failed" on following code : Option Explicit Sub copypasterow() ' ' chequerecieving Macro ' copy active row to another workbooks last row ' ' Keyboard Shortcut: Ctrl+l ' Dim wbTarget As Workbook...
  4. P

    Runtime error 91

    I have a model that performs an automatic hide of a formular bar depending on what cells you pick (password entering cells and so on). There is a function that does this: Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Selection.Count = 1 Then If Not...
  5. M

    runtime error 1004

    Hi There, I am getting a runtime error on the following? It basically puts some data into a couple of tabs, then saves those two tabs as a pdf. Inputs new data and creates a pdf again in a loop. There are about 25 iterations of this required. But after somewhere between 5-7 I get a runtime...
  6. rhino4eva

    Help with error codes ... what am i missing???

    lastrow = Sheets("Sheet1").Range("A" & Rows.Count).End(xlUp).Row For Count = 2 To lastrow Range("$a$2:a" & lastrow).Find("Sample").EntireRow.Select Selection.Delete Shift:=xlUp Next Count End Sub I am trying to develop a module to scan thru sheet1 and delete every line where the word "Sample"...
  7. A

    Left Function & Runtime Error 5

    I keep having a runtime error 5 at the part with the Left function, Thank you. For Each c In Range("E592:E593").<wbr>SpecialCells(<wbr>xlCellTypeVisible) mth = c.Text MsgBox mth If Left(mth, InStr(mth, "/") - 1) = Month(Date) Then c.Offset(0, 21).ClearContents Next
  8. ClimoC

    Collection of UserForms at Runtime - Opening and Closing?

    Hello I've been around the woodwork with this one, so hopefully I haven't gone totally off track. Got the feeling I'm straying into the OO problems of VBA/VB6... Desired Outcome: Creating (no more than 2 at any one time) multiple instances of the same Userform, at runTime, and then referring...
  9. M

    Runtime error '424' issue

    I am running into the runtime error '424' Object required issue. I am using the variable eRow in order to enter data from a userform into the next available row in a excel sheet. I can't find any issues with the code, it was working a couple weeks ago. Here is a shortened version of what I am...
  10. R

    Excel - runtime error 13

    Hello Everyone,<o:p></o:p> <o:p> </o:p> Can someone please help me to resolve this issues.<o:p></o:p> <o:p> </o:p> I have been getting the Runtime error '13' type mismatch.<o:p></o:p> Please try this process to get the error message and youwill know what I meant. 1st – Go to the userform and...
  11. A

    runtime error 424

    Using Excel 2013. I have a runtime error 424, and the code will stop at the IF line. What is wrong with the code? Sub test () Option explicit dim ThisPeriod , LastPeriod as string ThisPeriod = Range("B3") LastPeriod = Range("B6") If Left(ThisPeriod, 1).Text = "S" And...
  12. R

    Runtime error 1004

    Hello, I'm having an issue with my excel macros. I built some macros that run without any issue at all for me. When my colleague tries to run the exact same macro stored in the exact same place it comes up with the 1004 runtime error, not being able to find selection files. Is this a common...
  13. M

    Runtime error when using FSO to create a text file in VBA

    I'm using File System Object to create a text file but when I run the code I'm getting a runtime error that I don't recognize. Code works fine if the text file exists and it just executes and overwrites the existing file. The code is: Sub main() Dim fso As FileSystemObject Dim Fileout...
  14. S

    Write cell formula w VBA

    I've written several formulas via VBA without issue, but I'm having a problem with 2 formulas. I thought I had a resolution of the issue using a solution found on an Excel VBA site but that has not resolved the problem: Here's what I have as the VBA code for testing. I'm getting a 'RunTime...
  15. S

    runtime error '13' type mismatch

    Hey all, Getting a runtime error when trying to save worksheet an send as email. This is the highlighted line I'm seeing when hitting debug. excel- 2010 strFileName = ws.Cells("1", "Q") & ".xlsm"
  16. R

    runtime error

    Greetings, I noticed that that "offsets" are used by a lot of you when you are ranging userforms and input boxes. It seems like a pretty good technique to use instead of hard coding ranges so I thought that I would start learning this. If I understand this correctly the first column is the row...
  17. B

    Looking for programming advice and understanding errors

    Hi all, thank you for taking the time to read this. I am currently working on a code in which an engine can be running in four possible states: On, Off, Automatic and Manual. I am trying to find the total number of hours it is running in manual. The code is as follows: 'START' Dim run_time As...
  18. B

    Assign all controls to my collection or group on runtime

    Hi All, i'm trying this all day so now it's time to ask the experts. I think i'm close but not sure.... I have a userform with 6 lines. Each line contain some controls like textboxes, commandbuttons and comboxes. With a press of a button i can create a new line of controls underneath them. All...
  19. K

    A problem with adding and deleting dynamic controls in a userform

    Hello all, I have been tinkering about with a userform for the past week but I've come up against a slight problem. The Userform that I have created contains both dynamically created controls and a template. The template controls are all working fine and I have managed to get the userform to...
  20. StevenAncel

    Runtime Error 91 - I've 'Dim' and 'Set' already tho!?

    Im creating a macro for my work. The oddest part of all this, is that the macro seems to run past the highlighted section. It creates the email and puts the TO: CC: BCC: and copies over the content and everything. It basically creates teh email just how i want, but gives an error ---- also...

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