/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

1 vote159 views1 answer
How to put a gridpain in a vbox
VBA
0 vote164 views1 answer
Vba type variable
VBA
0 vote161 views1 answer
How to carry text to the next line in a label in vb.net
VBA
2 votes169 views1 answer
Excel vba check if string entirely alpha
VBA
0 vote160 views1 answer
Vba shape transparent
VBA
0 vote165 views1 answer
Vba character ascii code
VBA
1 vote161 views1 answer
Excel vba close form escape key
VBA
0 vote157 views1 answer
Vlookup columns not next to each other
VBA
0 vote166 views1 answer
Remove first character from string vb
VBA
0 vote163 views1 answer
Not allow form to be resized
VBA