/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

2 votes185 views1 answer
Excel vba check if string entirely alpha
VBA
0 vote174 views1 answer
VB get external IP address
VBA
1 vote171 views1 answer
Add control vb
VBA
0 vote168 views2 answers
Excel vba copy paste after last row
VBA
1 vote185 views1 answer
Excel vba last row of range
VBA
0 vote195 views1 answer
Excel web scraping
VBA
0 vote174 views1 answer
Excel vba scroll to cell
VBA
0 vote187 views1 answer
Vbs expand env var
VBA
0 vote179 views1 answer
Excel vba range contains
VBA
0 vote190 views1 answer
Vbs run with cscript
VBA