application-defined

  1. Mackeral

    Why do I get error msg "Application-defined or object-defined error" when I Reset in VBA?

    Shouldn't VBA end at a "Reset" and not give an error message. And once I click "Ok" on the error message, I can re-execute the macro with no restrictions. Thanks for your help.
  2. G

    Application-Defined or Object-Defined Error on Range Resize

    When i try to resize a range after offsetting it I get an Application-Defined or Object-Defined Error. Can't understand why. Sub test() Dim sourceSht As Worksheet Dim targetSht As Worksheet Dim LastRow As Long Dim selectedData As Range Set sourceSht =...
  3. T

    Application-defined or object-defined error

    I am trying to return the contents of a fairly large array but get this error message: Application-defined or object-defined error my array contains about 15000 rows and 50 columns. Sheet1.Cells(1, 1).Resize(15000, 50).Value = MyArray If I change the 50 to say 30, it returns the...
  4. V

    #1004 Application-Defined Error

    Hi, I am facing #1004 Application-Defined Error issue when try to apply below formula with VBA. The actual formula is : =IFERROR( IF(INDEX('Source data'!$D$4:$ES$40003,MATCH($G5,'Source data'!$EF$4:$EF$40003,0),MATCH(H$3,'Source data'!$D$4:$ES$4,0))="N", INDEX('Source...
  5. Roderick_E

    Validation.Type

    Apparently some cells don't have any validation types set??? Thus my following code throws an error popup? Sub valtype() MsgBox ActiveCell.Validation.Type End Sub ERROR: Runtime error 1004 Application-defined or object-defined error I want to check for this potentiality and then do something...
  6. S

    .Formula = "=IF(..." Application-defined or object-defined error

    Hello, I am receiving the Run-time error '1004': Application-defined or object-defined error for the below. As you can see from the sample code, there is a bit right before which has a similar set-up and it works fine. I believe it is a syntax error of some sort (like missing quotes, or an extra...
  7. P

    Run-time error 1004: Application-defined or object-defined error?

    Hello, the idea is to center an image in the middle of a cell where the cell's size is variable. This shall be done for a column of images if a certain cell in the same row contains content different from 0. If not the image shall be invisible. Can you please help me to identify the problem...

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
Back
Top