/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 vote307 views1 answer
Show unix time in vba
VBA
0 vote312 views1 answer
Vbscript for loop
VBA
2 votes296 views1 answer
Vba array contains
VBA
0 vote333 views1 answer
Create links in msgbox in vb
VBA
0 vote358 views1 answer
Programmatically copy data from one workshet to another excel
VBA
1 vote280 views1 answer
Vba listindex select multiple items vba
VBA
31 votes449 views1 answer
Excel vba function to convert column number to letter
VBA
22 votes518 views1 answer
Xl vba check for folder
VBA
1 vote313 views1 answer
Vbs run
VBA
0 vote326 views1 answer
Vba run command
VBA