application-defined

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.

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

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

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

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

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

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