Runtime error 9 - can't find the problem

Hi Everyone,

I'm new to VBA and to this forum. I have written a piece of code and it keeps giving me a runtime error 9. Can somebody explain me why it is.

The purpose of the macro is to create a new file based on the value of a cell and then copy some worksheets from the source file to the target file and then, using advanced filter, copy some rows to the target file.
At first i tried to assign all worksheet and workbook names to variables but then i got runtime error 9's for almost every line.

Can somebody please help, i'm looking now for 3 hours plus to solve the problem but i can't make it work. And if possible, to make it work so that the names of worksheets and workbooks are variables.

The runtime error i get know is with

Please Login or Register  to view this content.

Many thx in advance!!

Please Login or Register  to view this content.

Many thanks Norie!! Works perfect now!!! I thought it would be something as simple/stupid as this...

And if, instead of working with the actual workbook and worksheet names, i would like to work with variables. How do have to do that? I tried it before but like i mentioned it gave runtime error 9's for almost every line... so i'm almost sure that i didn't declare the variables correct...

instead of using "P1515.xlsm", "bron.xlsm" and "BLANCO"... i would like to have them in variables because the P1515 is depending on the input of the user, and i will need this code again for other sheets...

i know P1515 is stores in the variable flName, but when i try to use it in Workbooks("flname") it doesn't work, the same when i put the name of a sheet in a variable and try to use in Sheets("variable") it doesn't work... -> runtime error 9

otherwise, i will try to rewrite it with variables and if it doesn't work i'll post my code again here

Again many many thanks Norie!!! It works PERFECT!!! I'm going to compare what you did with my attempt and learn from it...

Thx man!!!!