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

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! Working on a code to convert a part of a sheet into a CSV file: Problem is that I get "Run-time error '1004': Application-defined or object-defined error" when running it, stopping at "ActiveSheet.PasteSpecial Paste:=xlPasteValues". Any help? :) Sub ProdCSV()...

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

OK this is the weirdest thing. I just got a new laptop with Win 7 installed. (Yes we buy old products for new machines to save money.) anyway, this is not my choice. On my XP machine i had a simple paste/special values macro i put in my quick access toolbar because i do a lot of copy/paste. it...

Trying to copy rows of product information to new worksheets that are named after the products. Column BE2 has the product names without duplicates. Column U has the products randomly dispersed because items were sold at different times during the year. Hope this makes sense. Option Explicit...

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

I am getting "Application-defined or object-defined " error with the following code:(Written in ThisWorkbook) Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean) Dim flag As Variant flag = False Set rng = Worksheets("CIRC_BW").Range("A1", Range("A1").End(xlDown)) 'Set...