/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

31 votes483 views1 answer
Vba how to convert a column number into an Excel column
VBA
1 vote342 views1 answer
Excel vba force recalculation
VBA
0 vote334 views1 answer
Vbs send keys
VBA
31 votes481 views1 answer
Excel vba function to convert column number to letter
VBA
0 vote479 views1 answer
Vba array of integers
VBA
1 vote342 views1 answer
Excel vba first row in range
VBA
1 vote328 views1 answer
Excel vba autofit
VBA
-1 vote351 views1 answer
Vba code to add new column in table
VBA
0 vote342 views1 answer
Vba collection contains
VBA
0 vote336 views1 answer
Excel vba cell on change
VBA