Copy range to range

[neemi]

I am trying to copy a range of data from one worksheet in a workbook to another worksheet in another workbook and it doesn't work!! Is it possible to do this?
What am I doing wrong!!

I am trying to rewrite a copy and paste as am not keen on them!!
Please help..

My code is as follows:

With pwbkInput.Worksheets(1)

Application.Workbooks(1).Worksheets(1).Range("A4:I22"= .Range("B5:J21"))

etc
etc

 

[PHV]

Perhaps this ?
pwbkInput.Worksheets(1).Range("B5:J21").Copy Application.Workbooks(1).Worksheets(1).Range("A4:I20")

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886