Error 1004

[Luke777]

Hi all,

bit confused by this one

Why does this give the 1004 error - application defined or object defined error

Sub FillData1()

    Dim ws3 As Worksheet

    Set ws3 = Worksheets(3)
    
    ws3.Range("F3").End(xlRight).Select

End Sub

But this does not?

Sub FillData1()

    Dim ws3 As Worksheet

    Set ws3 = Worksheets(3)
    
    ws3.Range("F3").Select

End Sub

Why does the .End function cause an error?

 

[Fluff]

Try xltoRight, rather than xlRight