/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 vote247 views1 answer
Thread sleep vb
VBA
1 vote239 views1 answer
Excel vba compare 2 rows
VBA
5 votes270 views1 answer
Vba low byte from INTEGER
VBA
0 vote256 views1 answer
Excel vba protect scenarios
VBA
2 votes243 views1 answer
Vba split string
VBA
0 vote243 views1 answer
Excel vba saveas no prompt for overwrite
VBA
0 vote228 views1 answer
Refresh token em vb net
VBA
3 votes245 views1 answer
Extract the nth word from a text string
VBA
0 vote240 views1 answer
Combobox dropdown search visual basic -excel -C#
VBA
1 vote245 views1 answer
Add rows to datagridview vb.net
VBA