What row did you replaced??

"Kari J Keinonen" wrote:

Hy!

I don't replace that row.

Regards Kari J Keinonen

"Oldjay" wrote:

When I replace "Windows("TempData.XLS").Activate" with

Workbooks("TempData.XLS").Sheets(1).Range("D2").Se lect

I get a 1004 "Select method of Range class failed" at this new line

oldjay




"Kari J Keinonen" wrote:

Hello!

I change one row, and it works me!

Workbooks("TempData.XLS").Sheets(1).Range("D2").Se lect

Regards Kari J Keinonen