Logo 
Search:

MS Office Answers

 Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Koila Malik   on Aug 18 In MS Office Category.

compare data from different worksheets


  
Question Answered By: Gerardo Morgan   on Aug 18

We clarified our own misunderstanding and rewrite a few line thus

> Set mws = Sheets(1)
> Set mrng = Range(mws.Cells(2, 2), mws.Cells(2, 2).End(xlDown))
> Set cws = Sheets(2)
> Set crng = Range(cws.Cells(2, 2), cws.Cells(2, 2).End(xlDown))

Share: 

 

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

 
Didn't find what you were looking for? Find more on compare data from different worksheets Or get search suggestion and latest updates.


Tagged: