/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

3 votes296 views1 answer
Excel vba last row in range
VBA
0 vote332 views1 answer
Excel vba prevent saving workbook
VBA
0 vote332 views1 answer
Loop through all text boxes in a form vb
VBA
5 votes890 views1 answer
Vlookup vba
VBA
0 vote321 views1 answer
How to set location and size of new from vb
VBA
0 vote328 views1 answer
Excel vba remove formatting from cell
VBA
0 vote306 views1 answer
Vba loop through table
VBA
0 vote365 views1 answer
Visual basic run command
VBA
0 vote301 views1 answer
Vba file size
VBA
2 votes314 views1 answer
Excel vba check if string entirely numeric
VBA