Setting a range in non-active workbook

I have a userform with a button, and when pressed it refers to a range within the workbook it is generated from. If the workbook if active, the code works fine, but if another workbook is active the code does not work.

Is there a way to set the range like i have tried below?

wbName and wsName are references to the workbook the userform is generated from.

Please Login or Register  to view this content.

Many Thanks

Thats great, works a treat.

Many thanks for your help.