object-defined error

  1. E

    Finding last Green (5287936) Filled Cell in Row

    Happy Friday, I am attempting to find the last green (color Id=5287936) filled cell for each row in a data set. Once found I need to report the appropriate column label - (text present in row 4), for each identified green filled cell. I know I would need a for loop in order to loop through the...
  2. T

    Help with Saving Spreadsheet as PDF using VBA

    Hey y'all, For a work project I am attempting to save a spreadsheet as a pdf in a specific folder but I now that I have figured out how to navigate to that folder (or create it if it doesn't already exist), I keep getting a fail to print error for an undefined object. Due to the nature of my...
  3. S

    Code works or throws error sometimes

    Hello all, I've been trying to figure this out for a while now (I hope it is right in front of my face and I just can't see it). I have a line of code that works when it is ran in its sub, but throws an error when that sub is called upon. I get a "Run-time error '1004': Application-defined...
  4. S

    VBA to Copy/Paste from one sheet to another. Application-Defined error. I'm lost.

    Hi all, first post of mine to this forum. I've been working with this bit of VBA for a few hours now, but haven't been able to figure it out. Needless to say, I'm not very good in VBA. I am trying to copy several rows from one sheet to another, making sure that the pasted content starts on...
  5. J

    Application/object defined error 1004 - Autofilter

    Hi I'm trying to add an autofilter to a row where the first 3 columns of data are refreshed from an external data source and the next 4 columns of data are formulas (Range A4:G#varies). I can manually add an autofilter to this row outside of VBA, but when I try to use code the subject error...
  6. D

    Error 1004 using Worksheet_Change if multiple cells are changed using paste

    I'm using Excel 2007 I have a Spreadsheet with two sheets, one for data entry and one with a set of data for lookup I have written a Worksheet_Change macro that when an ID is entered into column 3 of the data entry sheet, it looks up certain columns in the data and if they are blank puts a cross...
  7. K

    VBA application-defined or object-defined error

    Greetings all. We have a shared Excel 2003 file that up to 7 of us access every day, all day, everyone using Excel 2003. This shared workbook opens another work book that has a bunch of macros used by the shared sheet. We have been using this file for YEARS with no issues but recently my...

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