Hello friends help me with Macro to copy from one work book to another.
I have two workbook.
1. Students
2. Subject
. I wanted to copy row D from subject workbook to row D in students workbook.
What i have tried is:
Workbook("subject").sheets("detail").range("d2:d40").copy_
Workbook("students").sheets("detail").range("d2:d40")
But this is giving me slme error(script out of range)
Thank you
I have two workbook.
1. Students
2. Subject
. I wanted to copy row D from subject workbook to row D in students workbook.
What i have tried is:
Workbook("subject").sheets("detail").range("d2:d40").copy_
Workbook("students").sheets("detail").range("d2:d40")
But this is giving me slme error(script out of range)
Thank you
Last edited: