hi am trying to copy a range from source workbook to a worksheet in
destination workbook(closed) in a different drive. i checked previous
topics but i am unable to get appropriate code to copy range to closed
workbook. please help