setting a range to a different workbook

[JRJLHJ1823]

have a select case that looks for a value in the workbook this code is in and I am trying to set a range to a different workbook.. I keep getting a out of range error.. any ideas on what im doing wrong?

Please Login or Register  to view this content.

[Norie]

Path2 and/or msg must be wrong.

[JRJLHJ1823]

hmm looks right.. im trying to set it as a string.. I don't want the cell value I just want the cell