/VBA/Vba find last row in range for certain criteria

Vba find last row in range for certain criteria

Excel vba last row of range

Dim rRange As Range
Dim rDuplicate As Range

Set rRange = ActiveSheet.UsedRange
lFirstRow = rRange.Row
lLastRow = rRange.Rows.Count + rRange.Row - 1
lFirstColumn = rRange.Column
lLastColumn = rRange.Columns.Count + rRange.Column - 1
' New reference to current range (can be truncated)
Set rDuplicate = Range(Cells(lFirstRow, lFirstColumn), _
      Cells(lLastRow, lLastColumn))

Vba find last row in range for certain criteria

Range("E3:E" & Cells(Rows.Count, "F").End(xlUp).Row) = DateSerial(Right(Range("Q1"), 2), 4, 1)

Source: mrexcel.com

Similar codes

25 votes269 views3 answers
String to date vb
VBA
-1 vote148 views1 answer
System.Data.OleDb.OleDbException: 'No value given for one or more required parameters.'
VBA
0 vote143 views1 answer
How to convert weeks to days into textbox with VB site:stackoverflow.com
VBA
1 vote142 views1 answer
Excel vba first and last row and column in range
VBA
0 vote135 views1 answer
Vbnet line graph smooth lines
VBA
0 vote132 views1 answer
Vba text to general
VBA
5 votes141 views1 answer
Excel vba high word from Long Integer
VBA
0 vote146 views1 answer
Vbnet find highest value in chart
VBA
0 vote139 views1 answer
Compare dates vb
VBA
0 vote132 views1 answer
Vba createparameter null
VBA