/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 vote279 views1 answer
Vbnet display all axis labels in cahrt
VBA
-1 vote271 views2 answers
How close excel through visual basic
VBA
0 vote298 views1 answer
Excel vba remove formatting from cell
VBA
0 vote289 views1 answer
Replace spaces with underscores vbnet
VBA
0 vote295 views1 answer
Enable macros on opening workbook vba
VBA
0 vote280 views1 answer
Excel vba copy entire sheet paste values
VBA
0 vote305 views2 answers
Get unique random number in vb.net
VBA
0 vote302 views1 answer
Vba cell all borders
VBA
1 vote289 views2 answers
Vba string to date
VBA
5 votes352 views1 answer
Excel vba last byte from INTEGER
VBA