Trouble with Dynamic Range

Hello All,

I hope someone can help me out with this issue. I have hundreds of excel files from which I'm extracting data and copying on to a new worksheet.
Each set of data is associated to a Project ID that I must copy to each row of data once it is copied. The set of data can range from 1 to presumably 65536 rows.

I've written the code below thinking I had it, but my destination range gives me a runtime error of 438. I believe my syntax might be wrong but can't quite figure it out.

Thanks in advance for the help.

J.

Please Login or Register  to view this content.

Hi

Try changing

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

rylo

Rylo,

Thanks a lot! I think it was the "Type:=xlFillDefault" that was causing problems.

Thanks again...

J.