/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 vote308 views3 answers
Write to text file vb.net
VBA
0 vote311 views1 answer
Vba integer to double
VBA
3 votes316 views1 answer
Extract word in a text in excel
VBA
3 votes310 views1 answer
Excel vba make long from two shorts
VBA
0 vote289 views1 answer
Vb get ip address
VBA
1 vote304 views1 answer
Excel vba to lower case
VBA
0 vote278 views1 answer
Vlookup columns not next to each other
VBA
5 votes324 views1 answer
Excel vba first byte from INTEGER
VBA
0 vote293 views1 answer
Vba min
VBA
0 vote290 views1 answer
Vbnet hex to binary
VBA