/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 vote241 views1 answer
How to carry text to the next line in a label in vb.net
VBA
0 vote230 views1 answer
Excel vba select multiple shapes
VBA
0 vote235 views1 answer
Excel vba send HTTP POST to server
VBA
0 vote242 views1 answer
Telephon call in vba
VBA
1 vote233 views1 answer
Excel vba last column in range
VBA
1 vote244 views1 answer
Add rows to datagridview vb.net
VBA
0 vote254 views1 answer
Vba range clear formatting
VBA
1 vote242 views1 answer
Vba login website
VBA
0 vote247 views1 answer
Excel vba unmerge sheet
VBA
0 vote238 views1 answer
Delete rows in excel vba code
VBA