/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 vote151 views2 answers
Excel vba close without saving
VBA
2 votes165 views1 answer
Excel vba check if string entirely alpha
VBA
0 vote161 views1 answer
Excel vba unmerge sheet
VBA
0 vote151 views1 answer
System.InvalidOperationException: 'Row associated with the currency manager's position cannot be made invisible.
VBA
0 vote166 views1 answer
VBA Sort RossetaCode
VBA
4 votes156 views1 answer
Vba create directory
VBA
2 votes160 views1 answer
Excel vba date to string conversion
VBA
0 vote164 views2 answers
Do until loop vba
VBA
0 vote244 views1 answer
Find the name of the last excel sheet vb
VBA
0 vote154 views1 answer
Enable macros on opening workbook vba
VBA