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

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

I am trying to delete the rows on a filtered worksheet with this code: .Range("A:R").AdvancedFilter Action:=xlFilterInPlace, CriteriaRange:=ws_vhold.Range("A2:A3") Set RngList = .Range("A1:R" & .Cells(Rows.Count, "A").End(xlUp).Row).SpecialCells(xlCellTypeVisible) RngList.Resize(Rows.Count -...

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

I have tried to use several workarounds and other posts, but cannot seem to find a way to answer the error I am having. I am using Excel 2013 and am trying to grab information from a table to consolidate it. I could not get the range to work so I eventually added in the three lines before...

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

Hi All, I recently sent out a Business Plan document, produced in Excel, to approx. 100 users, each of whom would save their own copy, and populate it with data specific to them. Soon after I sent it out, I noticed a few errors with some formulae, so wanted to find a way of being able to...