/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 vote176 views1 answer
Set column width of datagridview vb.net
VBA
2 votes123 views1 answer
Excel vba pause
VBA
0 vote209 views1 answer
Set datetimepicker value to null vb
VBA
0 vote174 views1 answer
Vba run command
VBA
0 vote173 views1 answer
How to extract a file from an ISO:
VBA
0 vote133 views1 answer
Excel vba arrondir
VBA
0 vote180 views1 answer
Search combobox items vb.net
VBA
1 vote165 views1 answer
Vba delete array element
VBA
-1 vote176 views1 answer
Vba code to add new column in table
VBA
1 vote185 views2 answers
Excel vba password protect
VBA