AdvancedFilter using 2 workbooks
 

Hi,

I am using 2 workbooks and I would like to use the data from one sheet
to fill in a validation cell in another workbook.

In the workbook "Data" I set a range named "NoPO" wich contain the data
I want to filter. In the workbook "User" I would like to copy the
filter result in the range named "ExtractionNoPO"

My VBA code is:
[NoPO].AdvancedFilter Action:=xlFilterCopy,
CopyToRange:=[ExtractionNoPO], Unique:=True

Should I add something to the code to make sure I will work. I get an
error 424.

Thanks a lot

Frank


--
yoshi88
------------------------------------------------------------------------
yoshi88's Profile: http://www.excelforum.com/member.php...o&userid=36711
View this thread: http://www.excelforum.com/showthread...hreadid=564449