Logo 
Search:

MS Office Answers

 Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Eden Jones   on Oct 07 In MS Office Category.

Copy_To_Another_Workbook


  
Question Answered By: Kaysah Mohammad   on Oct 07

but the problem is whenever the value is not the same the the range  that
being coped into will turned to #REF



How to avoid this ? is it because the copy  range is from a range that
have links/formula?





. If ThisWorkbook.Sheets("shiftreport").Range("b541") <>
DestSheet.Range("b2").Value

Share: 

 

This Question has 8 more answer(s). View Complete Question Thread

 
Didn't find what you were looking for? Find more on Copy_To_Another_Workbook Or get search suggestion and latest updates.