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