excel vba last row in range vba find last row in range for certain criteria

The solution for “excel vba last row in range vba find last row in range for certain criteria” can be found here. The following code will assist you in solving the problem.

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 resized / moved)
Set rDuplicate = Range(Cells(lFirstRow, lFirstColumn), _
Cells(lLastRow, lLastColumn))Range(“E3:E” & Cells(Rows.Count, “F”).End(xlUp).Row) = DateSerial(Right(Range(“Q1”), 2), 4, 1)

Thank you for using DeclareCode; We hope you were able to resolve the issue.

More questions on [categories-list]

Similar Posts