run time error

I have the following code generating a run time error on a protected sheet. Error message is: Method "Goto' of 'object' _Application failed This is used to simply lookup the current date. The issue begins at "Application.Goto Rng, True" Any assistance would be appreciated and thanks in...

Dear friends I have created a sheet for database containing macro which also does data validation for blank cells. It is working fine when I am doing manual entry. But when I do copy paste from another sheet it gives runtime error ' type mismatch 13, end or debug option' I need to do copy...

Hello, I have the following code producing a run time error. It actually works and and gives me the proper output but it also gives me a run time error '13' for some reason. The purpose of this code is when a user chooses a Family Name from a combo box, a field called txtFamilyID is populated...

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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