Question : excel vba last row
Answered by : vastemonde
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))Source : | Last Update : Fri, 22 Jan 21
Question : vba find last column in a row with data
Answered by : successful-starling-4ylwg02mukwz
Select All
last_col = Cells(1, Columns.Count).End(xlToLeft).ColumnSource : https://www.teachexcel.com/excel-tutorial/1883/find-the-last-column-with-data-in-excel | Last Update : Thu, 20 Jan 22
Question : vba find last row in range for certain criteria
Answered by : excited-echidna-dhhw8ndjwi6g
Range("E3:E" & Cells(Rows.Count, "F").End(xlUp).Row) = DateSerial(Right(Range("Q1"), 2), 4, 1)Source : https://www.mrexcel.com/board/threads/getting-last-row-with-data-from-another-column-and-setting-cells-in-a-range-to-a-date.1162348/ | Last Update : Thu, 30 Sep 21