i am getting subscript out of range error when i am using th
Windows(Filename).Activate command to switch from one open work book t
another....

Is this the correct way? or should i be using another command...?

All i want to do is the following...

Switch to WKBK2
Copy Cells
Switch to WKBK1
Paste Cells
Switch to WKBK2
Copy more cells
Switch to WKBK1
Paster more cells

:

--
Message posted from http://www.ExcelForum.com