Which is better line in code for Module

[hsandeep]

In Module of my Workbook (coded.xlsm) and for the Worksheet (tab named “ZZZ”) I am using User Defined Function to get outputs in some cells where UDFs are there.

1 line of the code is

If Sheets("ZZZ").Range("WA10").Value = "=1" Then
GoTo finish
End If

Should I replace the above lines with?

If Application.Workbooks(“coded.xlsm”).Worksheets(“ZZZ").Cells(10, 599).Value = "=1" Then
GoTo finish
End If

Motto is

1. speed of execution of the code & of course
2. I don’t know whether the 2nd line/(s) would perform correctly or not?

Can some gurus of this forum help?
Thanks in advance

 

[Fluff]

I would use

If ThisWorbook.Sheets("ZZZ").Range("WA10").Value = "=1" Then

but that's just personal preference.

 

[hsandeep]

I would use

If ThisWorbook.Sheets("ZZZ").Range("WA10").Value = "=1" Then

but that's just personal preference.

I'll try your above line tomorrow in the Module of my Workbook with real time data feeds in 1 Worksheet & then come back with the outcome.

 

[Fluff]

Ok,

 

[hsandeep]

Ok,

Yours is better. Thanks Fluff

 

[Fluff]

You're welcome & thanks for the feedback.