by
0
1
24
0
Specified
This snippet is Public
No tags for this snippet yet.
Languagecsharp
Languagevhdl
LicenseMIT_X11

Get RowNum

Copy Embed Code
<iframe id="embedFrame" style="width:600px; height:300px;"
src="https://www.snip2code.com/Embed/4639211/Get-RowNum?startLine=0"></iframe>
Click on the embed code to copy it into your clipboard Width Height
Leave empty to retrieve all the content Start End
// Enter here the actual content of the snippet. Function GetRowNum(Simpson_son_tarih) Dim lrow As Long //Specifies that when a run-time error occurs, control goes to the statement immediately following //the statement where the error occurred, and execution continues from that point. Use this form rather than On Error GoTo when accessing objects. On Error Resume Next lrow = Application.WorksheetFunction.Match(Simpson_son_tarih, Worksheets("Data").Range("a1:a5000"), 0) //Disables enabled error handler in the current procedure and resets it to Nothing. On Error GoTo 0 If lrow > 0 Then 'code GetRowNum = lrow End If End Function
If you want to be updated about similar snippets, Sign in and follow our Channels

blog comments powered by Disqus