object-defined error

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

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

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

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

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

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

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