/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 vote258 views4 answers
Jwt token vb.net validation
VBA
5 votes246 views1 answer
Excel vba how to unit test vba code
VBA
0 vote228 views1 answer
Vba simple quote
VBA
0 vote229 views1 answer
Vbnet line chart showing extra space
VBA
0 vote210 views1 answer
Excel VBA web scraping
VBA
0 vote215 views1 answer
Not allow form to be resized
VBA
0 vote242 views1 answer
Excel vba DisplayAlerts
VBA
0 vote229 views1 answer
Vba listbox remove all items
VBA
0 vote222 views1 answer
Switch pictures with buttons vb.net
VBA
0 vote236 views1 answer
Default host vbox address
VBA