View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Kari J Keinonen[_2_] Kari J Keinonen[_2_] is offline
external usenet poster
 
Posts: 20
Default Command button failure

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