/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 vote155 views1 answer
Vbs expand env var
VBA
8 votes171 views1 answer
Excel vba make integer
VBA
8 votes197 views1 answer
Excel vba make word
VBA
0 vote140 views1 answer
How to set location and size of new from vb
VBA
0 vote143 views1 answer
Vba like with wildcard
VBA
1 vote146 views1 answer
Add control vb
VBA
0 vote149 views1 answer
WGET FTP
VBA
1 vote160 views1 answer
Excel vba last row of range
VBA
3 votes154 views1 answer
Vba http request json
VBA
0 vote157 views1 answer
Build an index all files of a FTP site
VBA