open sheets

[zhshqzyc]

Hi, I have two worksheets sheet1 and sheet2. I have to swith between this two sheets frequently grab data each other. Do I need to open them together?

Please Login or Register  to view this content.

Thanks for advice.

[royUK]

No, you don't need the first two lines of code, in fact line 2 cancels Line 1

It should be .Value not .Values