View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Gief Hell[_2_] Gief Hell[_2_] is offline
external usenet poster
 
Posts: 1
Default Problem with transfert between Sheets

Hi

I have every time the same error on the same instruction, the
instruction is in a module and the error is Run time error 1004
Application-defined or objet defined error

The fonction is :

Public Static Function ABC (Crit)

Dim i As Integer, j As Integer, k As Integer

k = Crit + 2

Instructions...

Problematic Instruction
Worksheets("PrioCrit").Range(Cells(7, "N"), Cells(44, "N")).Value
= Worksheets("Var").Range(Cells(57, k), Cells(94, k)).Value


End Function

What' s wrong ?

Thanks