run time error

  1. K

    VBA Run time error 13: Mismatch

    Hello, I am using the following subroutine and recently I have received a run time error stating type mismatch in regards to the line: Sep = Chr(9). I never had an issue with that line in the past. Any ideas? Sub DoTheImport() Dim shtName As String Dim Chr shtName = "Product " &...
  2. E

    Run time error from code capitalizing all cells in multiple ranges

    I implemented the following VB code to my excel sheet where I want all input within multiple ranges forced to capital letters. Code is as follows: Private Sub Worksheet_Change(ByVal Target As Range) If Not (Application.Intersect(Target, Range("E9:CQ19, E22:CQ32, E35:C45")) Is Nothing) Then...
  3. G

    Run Time Error 70 Permission Denied Excel VBA

    I have created some code that will move emails to a folder, add a unique ID, put into a spreadsheet and not overwrite duplicates. This worked when I made it and now it comes up with Run Time Error 70 Permission Denied. Been looking through the code and cant figure out where or why this is...
  4. J

    Select ALL cells problem and advice please

    Hi, and thanks for taking the time to view this post. I am running the following code to create 20 or thirty message boxes that activate when particular cells are clicked. Essentially, I need to provide the user information related to specific cell entries. My problem is when the user selects...
  5. T

    Run-time error= '5': invalid procedure call or argument

    I've been writing this vbs in excel to sort through some txt data and reformat it into excel. However, when I read in the .txt file, when it tries to save, it gives me this error: Run-time error = '5': invalid procedure call or argument Any help would greatly be appreciated...
  6. N

    Trying to Exit a Loop when VLookup no longer returns a valid value

    Hi All, I am new to posting, so if I need to provide more details, please do not hesitate to let me know. Thank you in advance for any assistance you can provide! I have a column with a Status in it ("Awarded", "Lost", and "Pending" are the options). I am trying to look down that column and...
  7. C

    Why did I get this ERROR? - Criteria Expression

    Does anyone know why this error occurs when it hits this line of code? Range("M5").PasteSpecial Paste:=xlPasteValues "Run-time error '-2147217913(80040e07)': Data type mismatch in criteria expression. Here's the full code: Sub MOD_35BBB_UNDHIDE_ALL_COLUMNS_AND_ROWS_PASTE_SPECIAL_DATA_SAVE()...
  8. B

    run-time error '-2147417848 (80010108)': Automation error

    Hi, I'm writing a macro in Excel 2013 and getting Run-time error '-2147417848 (80010108)': Automation error. The object invoked has disconnected from its clients. I have the error crash here in the module. It works twice, but on the third iteration it gives me this error For formulaG = 1 To...
  9. D

    Delete From VBA Code in Excel

    I am trying to create a VBA code in Excel 2010 which deletes all the rows from the table 'Info_Table' in SQL, but when I run the macro, I am getting the following error message: "Run-time error '-2147467259 (80004005)': Could not delete from specified tables." When I click on the Debug button...
  10. R

    Macro Run-Time error - Items (charts) not found

    Hi I've got an interactive chart on a sheet where users select a chart from a combo box control and a picture link to the chart is displayed. The actual charts are on a hidden sheet. I have to activate the charts first for it to work so I put a button the sheet and recorded a macro where I...
  11. L

    Run time error '9', macros in worksheet. Need help to debug

    Everytime I click on my macros button, I get a Run-time error '9': Subscript out of range message. I click on debug, it highlights the script: Private Sub Worksheet_Calculate() If Sheets("Checklist").Range("a62") = True Then Sheets("Contra_submittal").Visible = True <---Highlighted Else...
  12. S

    Error: "Unable to Set Hidden Property Range" for Xls 2007 Users, FIX?

    Hi All – </SPAN></SPAN> I’m hoping you can help correct this problem. I have a large workbook that will be delivered to several hundred users and requires many data entry fields, meaning the workbook and each of its worksheets need to be protected. On one of the worksheets, users of Excel 2007...
  13. ed.ayers315

    macro causing printing problem

    Hi Folks, Happy Mother's Day!! The following code is causing issues when I try to set up a print range with a macro. This error pops up Run Time Error '13': In the code below, the degger stops at the red font Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Not...
  14. M

    2003 macros/charts not working in 2007

    Hi - I have a workbook of macros written in 2003 version byut they keep hanging up in 2007 version...apparently in the Chart Type row withih VBA code. Hoping someone can help me here. Code (sorry it is so long) is pasted below. Error received on line: ActiveChart.ApplyCustomType...
  15. D

    Fixing Run-Time Error 6 Overflow

    I have a macro that I have been running successfully for several months now. All of a sudden I'm getting a Run-time 6 overflow message. All I'm doing is pulling a single staff members data from my master list. The Master sheet only has 500 lines of data on it.... Here is the Macro: Option...
  16. P

    Excel macro can't open word doc's that have templates

    Hey everyone, I've got a rather larger macro that runs from Excel and pulls data in from word documents. This macro works great for regular word documents that don't call templates. However, when the macro tries to open up a word document that is referencing a template, from what seems to be...
  17. V

    Excel sometimes fails with automation error The object invoked has disconnected from its clients

    Hi, Please help me in fixing the run time error problem Exact error message is "Run-time error'-2147417848(80010108)': Automation error The object invoked has disconnected from its clients" The above mentioned error comes occasionaly so it makes the macro unstable What is wrong in the...

Some videos you may like

This Week's Hot Topics

  • VBA (Userform)
    Hi All, I just would like to know why my code isn't working. Here is my VBA code: [CODE=vba]Private Sub OKButton_Click() Dim i As Integer...
  • List box that changes fill color
    Hello, I have gone through so many pages trying to figure this out. I have a 2020 calendar that depending on the day needs to have a certain...
  • Remove duplicates and retain one. Cross-linked cases
    Hi all I ran out of google keywords to use and still couldn't find a reference how to achieve the results of a single count. It would be great if...
  • VBA Copy and Paste With Duplicates
    Hello All, I'm in need of some input. My VBA skills are sub-par at best. I've assembled this code from basic research and it works but is...
  • Macro
    is it possible for a macro to run if the active cell value is different to the value above it
  • IF DATE and TIME
    I currently use this to check if date has passed but i also need to set a time on it too. Is it possible? [CODE=vba]=IF(B:B>TODAY(),"Not...
Top