/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 vote160 views1 answer
Windows Forms dark title bar
VBA
0 vote153 views1 answer
Excel vba assign shortcut key to button
VBA
0 vote165 views1 answer
Find database connection string vb
VBA
0 vote151 views1 answer
Vba apostrophe chr
VBA
1 vote164 views1 answer
Excel date to unix timestamp
VBA
0 vote161 views1 answer
Search combobox items vb.net
VBA
0 vote155 views1 answer
Remove first character from string vb
VBA
0 vote155 views1 answer
How to convert weeks to days into textbox with VB site:stackoverflow.com
VBA
0 vote149 views1 answer
Excel vba scroll to cell
VBA
0 vote157 views1 answer
Vba is integer
VBA