<div>
In your Validate_List sub you refer to a variable named TotRow. When the workbook is closed the Validate_List sub is called and if TotRow has not been set to some value the line<br />

<pre><code id="code-20-43281686-1">Range3 = &quot;a2:a&quot; &amp; Trim(CStr(TotRow))</code></pre>
resolves to <b>a2:a0</b> which is invalid.
</div>


In your Validate_List sub you refer to a variable named TotRow. When the workbook is closed the Validate_List sub is called and if TotRow has not been set to some value the line


Range3 = "a2:a" & Trim(CStr(TotRow))

resolves to a2:a0 which is invalid.

<div>
But I have got Type mismatch error to 2nd line below<br><pre><code class="code-1 nolinks" id="code-20-43281709-1">&nbsp; &nbsp; &nbsp; &nbsp; If Trim(CStr(Worksheets("Main Sheet").Cells(RowID, 19).Value)) &lt;&gt; "" Then
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; i_Day = Now() - Worksheets("Main Sheet").Cells(RowID, 19).Value

</code></pre>while Worksheets("Main Sheet").Cells(RowID, 19).Value is having value 30/04/2021. What is the reason of this?
</div>


But I have got Type mismatch error to 2nd line below


        If Trim(CStr(Worksheets("Main Sheet").Cells(RowID, 19).Value)) <> "" Then
            i_Day = Now() - Worksheets("Main Sheet").Cells(RowID, 19).Value



while Worksheets("Main Sheet").Cells(RowID, 19).Value is having value 30/04/2021. What is the reason of this?

IT Consultant

Peter Chan

<div>
<div class="content wysiwyg-content fr-view">
Hi,<br>I do not know why it is having data issue to save attached file.<br><br><br><a href="https://filedb.experts-exchange.com/incoming/2021/04_w18/1558984/Asset-Template-HK.xlsm" rel="ugc">Asset Template HK.xlsm</a>
</div>
</div>


Asset-Template-HK.xlsm


Hi,
I do not know why it is having data issue to save attached file.
Asset Template HK.xlsm

Data issue in Excel file

Excel Table

Visual Basic for Applications (VBA) enables building user-defined functions (UDFs), automating processes and accessing Windows API and other low-level functionality through dynamic-link libraries (DLLs). VBA is closely related to Visual Basic and uses the Visual Basic Runtime Library, but it can normally only run code within a host application rather than as a standalone program. It can, however, be used to control one application from another via OLE Automation. VBA is built into most Microsoft Office applications.

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.