/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

0 vote193 views1 answer
Vba argument is set
VBA
0 vote219 views1 answer
Excel vba Column Name from Column Number
VBA
0 vote211 views1 answer
VB get external IP address
VBA
8 votes293 views1 answer
Vba make integer
VBA
0 vote207 views1 answer
Excel vba send HTTP POST to server
VBA
0 vote198 views1 answer
Vba file size
VBA
0 vote201 views1 answer
Vb window.minimize
VBA
1 vote203 views1 answer
Vba reverse string
VBA
0 vote201 views1 answer
Vba like with wildcard
VBA
0 vote211 views1 answer
Vba compare strings
VBA