Hi.
Are the 2 books open at that time? I assume they are.
Replace the two 'Set' lnes by:
Set destSheet = Workbooks("data.xls").Worksheet("data")
Set sourceSheet = Workbooks("register.xls").Worksheet("register")

Regards,
Sebastien

"choice" wrote:

i have :

Sub inputdata()

Set destSheet = Worksheet("data")
Set sourceSheet = Worksheet("register")
Workbooks("data.xls").Activate
DestSheet(Range("a1:a10")).Value = sourceSheet(Range("a1:a10")).Value


my question/problem is that destsheet and sourcesheet are in different
workbooks...how would i add that in my code? i tried some stuff but couldnt
get it
the 2 workbooks are data.xls and register.xls
thanks in advance