/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 vote180 views1 answer
Vba format currency
VBA
0 vote177 views1 answer
Compare dates vb
VBA
3 votes192 views2 answers
Vba active workbook path
VBA
0 vote180 views2 answers
How to concatenate more than 40 lines in vba
VBA
0 vote184 views1 answer
Vbnet check if number is even or odd
VBA
0 vote168 views1 answer
Excel vba linter
VBA
0 vote171 views1 answer
Priavte sub with multiple handels find sneder
VBA
0 vote185 views1 answer
For each item in folder outlook vba
VBA
0 vote173 views1 answer
Add items to combobox vb.net
VBA
3 votes194 views1 answer
Extract word in a text in excel
VBA