<div>
because, each &nbsp;worksheet should have a name,<br />
<br />
this statement &nbsp;Worksheets(&quot;SelectedVoyage<wbr />&quot;) is already &nbsp;referring to the Worksheets &nbsp;&quot;SelectedVoyage&quot;<br />
<br />
what exactly do you want to do?
</div>


because, each  worksheet should have a name,

this statement  Worksheets("SelectedVoyage") is already  referring to the Worksheets  "SelectedVoyage"

what exactly do you want to do?

<div>
I want to check/confirm whether the worksheet with that name is existing in there, or not?
</div>


I want to check/confirm whether the worksheet with that name is existing in there, or not?

<div>
<div class="content wysiwyg-content">
Hi,<br />
I get<br />
<a href="https://filedb.experts-exchange.com/incoming/2016/02_w09/1083305/tt486.png" target="_blank" title="tt486.png (18 KB)"><img alt="tt486.png" class="file-block lazyload" style="max-width: 768px;" data-src="https://filedb.experts-exchange.com/incoming/2016/02_w09/1083305/tt486.png" /></a><br />
due to this line<br />
<br />

<pre><code id="code-10-28928777-1">    If (Worksheets(&quot;SelectedVoyage&quot;).Name = &quot;&quot;) Then</code></pre>
<br />
why?
</div>
</div>


tt486.png

Hi,
I get


due to this line

(CODE)

why?

Problem with Worksheet name

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.

Microsoft Office

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.

Visual Basic Classic

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

Microsoft Access

VBScript (Visual Basic Scripting Edition) is an interpreted scripting language developed by Microsoft that is modeled on Visual Basic, but with some important differences. VBScript is commonly used for automating administrative and other tasks in Windows operating systems (by means of the Windows Script Host) and for server-side scripting in ASP web applications. It is also used for client-side scripting in Internet Explorer, specifically in intranet web applications.