/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 vote191 views1 answer
How to get value from clipboard in vbnet
VBA
0 vote169 views1 answer
Switch pictures with buttons vb.net
VBA
0 vote163 views2 answers
Excel vba close without saving
VBA
1 vote179 views1 answer
Vba compile error object required
VBA
1 vote172 views1 answer
Excel vba convert cells(1,1) into A1 and vice versa
VBA
0 vote180 views1 answer
Excel vba prevent saving workbook
VBA
0 vote169 views1 answer
Vba len variant
VBA
0 vote208 views1 answer
How to enter Vbox manage commands
VBA
9 votes228 views2 answers
Excel vba convert 2 Short integers to a Long integer
VBA
0 vote188 views1 answer
VBA Sleep Snippet
VBA