Switch Between two Open Excel Files

gporonsk · July 23rd, 2013, 01:32 PM

I'm new to this and this part which seems like it should be simple to accomplish is driving me around the bend.

I have 2 part lists. I can Open each with a macro dialog box, select a bunch of cells to copy from one, but can't see how to switch to the other already open sheet to paste them down so I can compare them for differences.

Thank you for any and all help in advance.

JP.

Shasur · July 30th, 2013, 10:36 PM

Hi

You can try copying the selected content

Code:

Set oWS = ThisWorkbook.Sheets(4)
    OWS.Range("A1:A2").Copy ThisWorkbook.Sheets(5).Range("A1")

It would be better if you can explain in brief your requirement..

Cheers
Shasur