object defined error

Hi, I am trying to strip the quotation marks on a page. I used the following in a subroutine, Range("A10") = Right(Range("A10"), Len(Range("A10")) - 1), to remove one quotation mark and received the following error message. . I would appreciate your help. Thank you. Joe

I am printing outputs into cells, some of which use the Round feature and others don't. I am getting an error with this specific line: Worksheets("OUTPUTS").Cells(64, 4) = "= " & Round((TOTWT * 1.1), 0) & " lbs" The weird thing is that I do this multiple times throughout the code and I don't...

Hi People, I'm new to the whole posting situation but I'll explain the matter at hand as best as possible. SO I have VBA code, this code works GREAT in one workbook as a sub, then when I go copy and go paste from a sub into a Command Button the Code Goes "No." and gives a beautiful object...

I have created the following code to extract information from an excel table. But I am getting an error exactly at the if statement. I have even tried executing the code from a module and even from the worksheet level. I have read about this issue and it seems that selecting the sheet seems to...

I must be having a brain cramp on this one, I have not run into this problem before. I am trying to clear contents from a dynamic range in a workbook and I am getting an object defined error. I'm wondering if it is because I declared the "clear_rng" as a range, but don't understand why that...

Appreciate help with understanding how a VBA macro that works fine in Excel 2010 and 2013, but that generates an error (Run-time error '1004': Application-defined or object-defined error) when executing in version 2016 explicitly. The macro is embedded with a sheet in a workbook (the "Index"...

Appreciate help with understanding how a VBA macro that works fine in Excel 2010 and 2013, but that generates an error (Run-time error '1004': Application-defined or object-defined error) when executing in version 2016 explicitly. The macro is embedded with a sheet in a workbook (the "Index"...

Im trying to do something like this "om" is the if formula but in my language Range("f3").Value = "=OM(+'1'!H3=0;"";+'1'!H3)" and for some reason i get the 1004 application or object defined error when i do this the first line of code works but the same error appers on the next line, why...

Hi There, I am new to VBA, I have tried to write the code below. However, it says object required. I am new, but I thought I had everything in place. I essentially want the vba to take a value from a cell which is a sheet name in another document, take a column reference which is in cell H1...

Hello everyone i have encountered a problem with this run time error 1004 application defined error or object defined error can any one help me out of this. i have highlighted the line where the error occurred with a sad smiley please help me out Private Sub CommandButton1_Click() Dim lrow As...

Hi, I'm working on the code below and can't seem to figure out why I'm continually getting the application defined / object defined error. I had it working before and for some reason it's now giving me this error every time. The issue seems to surround the With Statement when the ".Pattern"...

I'm just trying to figure out what is happening with the following code (which is useless). I'm getting an error message in the last line of code saying that the object property is not supported by the wk object (or something to this effect): Sub Module() Dim wk As Workbook Set wk =...

Hi, I'm bored so I felt like making a pie chart of my cell phone data usage. I made a spreadsheet (table below) that has a column that labels each application and the corresponding data that it used. My macro then creates a second table of only the applications that used 2% or more of the total...

I have 3 spreadsheets. One form to enter the information, and two different spreadsheets that the information goes into (9月Spares, 9月Project). I have an activex button and two options and to be honest I'm kind of experimenting with them. The code executes if you click the "Enter" Button. If it...

I am trying to copy a column from pivot table into another column with unique values in same sheet.Pivot table header is in A6 to F6. That column contains Year values and there are no filters on it. While executing the below code it is showing an error like "Application Defined or Object...

Hi there, I have a macro to create a worksheet and it is not saving the file returning the error 424. In my code I define the folder and the file name. Dim Folder As String Folder = "A:\Controlling\2014\Reporting\CARS\Template\CARS\06_Jun\" Dim RSM As String Selection.Offset(0...

This is the macro what is the error.. When cell D40 is clicked all the macros are called and they are all the same (except ---- for different sheets).... When i debug it points to this an error - ""If Target.Address = "$D$40" Then Call Sheet9.Remove_Zeros"".... After i delete it it shows this as...

Hi,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> <o:p></o:p> I just started using VB to create macros in Excel recently and I could really use some help.<o:p></o:p> <o:p></o:p> This macro is intended to go through a column of identifiers in one...

[code]Sub Tabloop_Test3() Dim WS_Count As Integer Dim I As Integer Dim N As Integer Dim CellNum As String Application.ScreenUpdating = False WS_Count = ActiveWorkbook.Worksheets.Count For I = 3 To WS_Count Sheets("Overview").Cells(3, I -...

Hi all! I'm really hoping that someone will be able to help me out with my dilemma. I've built a spreadsheet that draws a cross-section and then calculates a bunch of properties based on it's dimensions. In a nutshell, you enter in the dimensions, select the cross-section type (three to...