/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 vote172 views1 answer
Excel vba automatic calculation
VBA
3 votes178 views1 answer
Excel vba change format of cell
VBA
8 votes339 views1 answer
Excel vba make word from bytes
VBA
0 vote164 views1 answer
Vba sheet visible
VBA
4 votes159 views1 answer
Excel vba check cell not empty
VBA
1 vote172 views1 answer
Shortcut to apply a formula to an entire column in excel
VBA
4 votes167 views1 answer
Vba create directory
VBA
0 vote177 views1 answer
Vba integer to double
VBA
0 vote166 views1 answer
Excel vba prevent saving workbook
VBA
0 vote209 views1 answer
Visual basic run command
VBA