/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 vote229 views1 answer
Vb net show lines for all axis labels in chart
VBA
1 vote242 views1 answer
Vba login website
VBA
1 vote237 views1 answer
Excel vba first and last row and column in range
VBA
1 vote246 views1 answer
Excel vba force recalculation
VBA
0 vote250 views1 answer
Regex numeric digits
VBA
0 vote249 views1 answer
Putting marquee in vb.net
VBA
0 vote253 views1 answer
Excel vba protect shapes
VBA
0 vote248 views1 answer
VB Error Code BC30201
VBA
0 vote366 views2 answers
VB
VBA
0 vote257 views1 answer
Selecttoken em vbnet e json
VBA