Good morning,
I'm using Excel 2010. In a subroutine that has always worked well in other programs, it now appears an error message 1004 in the definition of a range
Example:
Code
With Worksheets(Ws$)
Debug.Print .Cells(5, 3).Value 'OK
Debug.Print .Range("C5").Value 'OK
Debug.Print .Range(.Cells(5, 3)).Value 'Error 1004
End With
I do not understand. Any idea?
Thanks for your helping