/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 vote142 views1 answer
Vbide vbproject reference
VBA
1 vote194 views1 answer
Excel vba last row of range
VBA
0 vote186 views1 answer
Vbscript for loop
VBA
0 vote190 views1 answer
Loop through all text boxes in a form vb
VBA
0 vote145 views1 answer
Vba set vs dim
VBA
1 vote177 views2 answers
Vba string to date
VBA
0 vote178 views1 answer
Vba get text file content
VBA
0 vote196 views1 answer
Dynamically change drop down list visual basic
VBA
0 vote181 views1 answer
Vba sheet visible
VBA
0 vote183 views1 answer
Vbscript abs
VBA