/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 vote230 views2 answers
How to update date and time automatically once id is entered in excel vba
VBA
0 vote209 views1 answer
Vba createparameter null
VBA
6 votes229 views1 answer
Excel vba check if a string only contains alpha characters
VBA
0 vote220 views1 answer
How to make a a msgbpx in vbs
VBA
0 vote230 views1 answer
How to format a textbox as date vb net
VBA
0 vote167 views1 answer
How to make a if statement with vbs
VBA
0 vote199 views1 answer
Excel vba open browser
VBA
0 vote220 views1 answer
Excel protect cells with formulas
VBA
1 vote221 views1 answer
Excel vba make cell visible
VBA
0 vote222 views1 answer
Telephon call in vba
VBA