/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 vote166 views1 answer
Vba select file in folder
VBA
0 vote199 views1 answer
Vlookup columns not next to each other
VBA
0 vote144 views1 answer
How to make a if statement with vbs
VBA
11 votes264 views1 answer
Excel vba How to URL encode a string
VBA
1 vote203 views1 answer
Vb.net get name by Cell Click
VBA
1 vote209 views1 answer
Excel vba How to determine if a date falls on the weekend?
VBA
2 votes207 views1 answer
Excel vba check if string entirely numeric
VBA
0 vote190 views1 answer
Open application from vbnet
VBA
0 vote211 views4 answers
Jwt token vb.net validation
VBA
0 vote204 views1 answer
Get current url vb.net
VBA