application defined error

  1. 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...
  2. 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...
  3. 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...
  4. 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"...
  5. 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...
  6. 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...
  7. 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...
  8. 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...
  9. 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...
  10. 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...
  11. 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...
  12. 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...
  13. 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...

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