Dear programmers,

A short question. I have a filter in my excel file, which gets data
from Worksheet "Data1" and shows the filtered data in Worksheet
"Event1".

Set InputRange(1) = Worksheets("Data1").Range("A1:H500")
 Set OutPutRange(1) = Worksheets("Event1").Range("A1:H1")

I would actually prefer if those data from Worksheet Data1 would be
directly gotten from another file. Now, I am only copying in the
worksheets from one file to the other.

Do I have to define a String?
Or can I directly write it in the above-shown line?

Thanks for your help.

Regards,

Rico