/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

1 vote240 views1 answer
How to open cmd with vbd
VBA
0 vote272 views1 answer
Default host vbox address
VBA
0 vote281 views1 answer
Loop through each cell in dgv vbnet
VBA
-1 vote279 views1 answer
VBA check if a cell contains a letter or string
VBA
-1 vote271 views1 answer
How to correct a number to 2 decimal places in vba
VBA
4 votes271 views1 answer
Excel vba how to get a range's full address including sheet name
VBA
0 vote271 views1 answer
Vbnet make a string to unicode converter
VBA
0 vote285 views1 answer
Vba string
VBA
0 vote262 views1 answer
Vb streamreader
VBA
0 vote262 views1 answer
Discern between file and folder given path vb.net
VBA