I am receiving an error using the following code. I've noticed, however, that the error only occurs if the worksheet, "Transactions," is not the active worksheet. Is there a way to make this line of code work properly regardless worksheet tab that is selected?

[VBA]
Worksheets("Transactions").Range("A4").End(xlDown).Select
[/VBA]