auto filter... value from different workbook

**buzz71023** · 06-15-2012, 07:48 PM

I am still learning about Dimension in VBA but I am having trouble with this code. I am not sure if it has to do with my use of “Dim” or something totally different. Right now I am getting a compile error (object required). But in case I have this all wrong, what I am looking to do is open and auto filter a different workbook (CAF 10.xls) based on the result of the cell “ProductCode” in workbook “QCDS REST FORM”. For example if 100401 was entered into the cell ProductCode on sheet QCDS RESET FORM, I would like for workbook CAF 10.xls to autofilter its data to 100401.

Hopefully that is a good enough description, if not I will see what I can to

Please Login or Register  to view this content.

**shg** · 06-15-2012, 08:16 PM

VBA has two assignment operators, Let and Set. Set applies only to object variable, not scalar variables (strings, numeric variables, ...), and the Let keyword is optional.

So remove the word Set from the offending statement.