application defined error

  1. N

    VBA Application or object defined error

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

    Shapes.AddPicture - Application-Defined or Object-Defined Error

    This macro is supposed to add the most recent picture from my camera roll and insert it in the designated cell in Excel when a button is pressed on the worksheet. This macro was working at one point, but my guys ran into an issue with it last week, and I can't figure out why. It is giving me an...
  3. D

    Run time error 1004

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

    Application-Defined Error: 1004

    Hi Everyone, I have created the below code and a user defined function to- - To specify the range of cells based on the input dates -->sdate and edate variable -Run the user defined function searchcolumns based on input of range Below is the code Private Sub CommandButton2_Click() Dim rstr...
  5. E

    Application Defined / Object Defined Error

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

    Can't find my error

    Hi, I have the following code that is used to count a variable number or rows of raw data, then extend formulas to the last raw data row in columns M to Q in my spreadsheet. The error(User/Object defined error) occurs below in the line Selection.AutoFill Destination....etc Thanks for your...
  7. M

    Application-defined or object-defined error...

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

    Getting a 1004 error but I can't figure out why

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

    VBA Application Defined Error 1004

    I've been slowly making progress, and learning a lot! The size of my file (47 MB)! had something to do with it, got the go ahead to clear out the old data and was able to trim it to 33 MB. Now my computer doesn't lock up every time I us the file :). Still having run time errors. Now it's dying...
  10. G

    Run time error 1004.. :(

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

    Application defined or Object defined error (for copying and pasting)

    Sorry about the rudimentary nature of this question, but I am relatively new to VBA and can't work out what I am doing wrong. What I want to do is very simple: I have a sheet with four values on a row, followed by three blank rows and then another four values below that. What I wish to do is...
  12. A

    VB: run-time error '1004': Application-defined or object-defined error

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

    Error 400 Appears and Then Goes Away On Its Own

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

    VBA error! Can't seemt to debug :(

    Const CtyCount As String = 2 Const CtyName As String = 10 Const CapIQID As String = 12 Const BusUnit As String = 13 Const GovnDoc As String = 50 Const LegStat As String = 51 Const LegStatDate As String = 52 Const LegDocOwner As String = 53 Const LegContactName As String = 54 Const LegContactNum...
Learn Excel from Bill Jelen

Understanding data is crucial, and the easiest place to start is with Microsoft Excel.

This Week's Hot Topics

  • link pictures from Sharepoint to Excel macro
    Hi, I need your help to fix this issue. I have a code and this is work on my computer. But now I try to link the picture from the SharePoint to...
  • lookup match return closest to x date
    Hi all, Happy New Year, this is my first post in 2022. I have two worksheets I'm working with. worksheet one is titled KPI Data - MY22 ONLY It...
  • Average hours per week
    I'm trying to find a simpler/quicker way to obtain the average number of hours per week for employees. My spreadsheet contains columns for Date...
  • Google Sheets IMAGE Function
    Is there any way to replicate the IMAGE function from Google Sheets in Excel? Maybe a VBA code? From what I can tell, the function in Google...
  • Identify equipment used -No of consecutive days
    Hello, I appreciate your time and effort. I would like to have formula for column O and P. Column A : lots of Asset Column C: date If one Asset...
  • Filling in data from source
    Hi All, I'm not quite sure what to call the following type of data manipulation so I don't quite know how to phrase my question. Below is an...

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
Top