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
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