/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

1 vote157 views1 answer
Vba declare api 64 bit 32 bit
VBA
8 votes296 views1 answer
Vba convert 2 bytes to an integer
VBA
0 vote185 views1 answer
Iterate all file in a folder vba
VBA
0 vote159 views1 answer
Vb window.minimize
VBA
0 vote177 views1 answer
Vba dictionary length
VBA
3 votes163 views1 answer
Excel vba make long from two shorts
VBA
0 vote190 views1 answer
How to enter Vbox manage commands
VBA
0 vote178 views1 answer
Vbscript check if string contains
VBA
0 vote172 views1 answer
Supprimer la valeur de celule vba
VBA
0 vote156 views1 answer
Excel text to columns line break
VBA