Hi all,
bit confused by this one
Why does this give the 1004 error - application defined or object defined error
But this does not?
Why does the .End function cause an error?
bit confused by this one
Why does this give the 1004 error - application defined or object defined error
VBA Code:
Sub FillData1()
Dim ws3 As Worksheet
Set ws3 = Worksheets(3)
ws3.Range("F3").End(xlRight).Select
End Sub
But this does not?
VBA Code:
Sub FillData1()
Dim ws3 As Worksheet
Set ws3 = Worksheets(3)
ws3.Range("F3").Select
End Sub
Why does the .End function cause an error?