Breaking News: Grepper is joining You.com. Read the official announcement!

excel vba last row

Add Answer

VasteMonde answered on January 14, 2021 Popularity 10/10 Helpfulness 4/10

answer excel vba last row

related vba last row

related excel vba last column with data

related excel vba first and last row and column in range

related excel "vba" match last value

excel vba last row

Comment

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))

Popularity 10/10 Helpfulness 4/10 Language vb

Source: Grepper

Tags: excel range row vba

Link to this answer
Share Copy Link

Contributed on Jan 15 2021

VasteMonde

0 Answers Avg Quality 2/10

Closely Related Answers

vba last row

Comment

'1 is the Column in which the last row is being searched
lRow = Thisworkbook.Sheets("List").Cells(Rows.Count, 1).End(xlUp).Row

Popularity 9/10 Helpfulness 9/10 Language vb

Source: Grepper

Tags: row

Link to this answer
Share Copy Link

Contributed on Apr 28 2022

Energetic Echidna

0 Answers Avg Quality 2/10

excel vba last column with data

Comment

Dim rLastCell As Range

Set rLastCell = ws.Cells.Find(What:="*", After:=ws.Cells(1, 1), _
    LookIn:=xlFormulas, LookAt:= xlPart, SearchOrder:=xlByColumns, _
    SearchDirection:=xlPrevious, MatchCase:=False)

MsgBox ("The last used column is: " & rLastCell.Column)

Popularity 9/10 Helpfulness 5/10 Language vb

Source: Grepper

Tags: excel exce

Link to this answer
Share Copy Link

Contributed on Sep 04 2021

VasteMonde

0 Answers Avg Quality 2/10

excel vba first and last row and column in range

Comment

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))

Popularity 10/10 Helpfulness 5/10 Language vb

Source: Grepper

Tags: excel exce

Link to this answer
Share Copy Link

Contributed on Jan 14 2021

VasteMonde

0 Answers Avg Quality 2/10

excel "vba" match last value

Comment

'This is a code for a function that finds the last occurrence of a lookup value and returns the corresponding value from the specified column
Function LastItemLookup(Lookupvalue As String, LookupRange As Range, ColumnNumber As Integer)
  Dim i As Long
  For i = LookupRange.Columns(1).Cells.Count To 1 Step -1
    If Lookupvalue = LookupRange.Cells(i, 1) Then
      LastItemLookup = LookupRange.Cells(i, ColumnNumber)
      Exit Function
    End If
  Next i
End Function

Popularity 6/10 Helpfulness 1/10 Language vb

Source: trumpexcel.com

Tags: excel match vba

Link to this answer
Share Copy Link

Contributed on Oct 28 2021

Thoughtless Tapir

0 Answers Avg Quality 2/10

excel vba last row

Contents

More Related Answers

excel vba last row

Closely Related Answers

vba last row

excel vba last column with data

excel vba first and last row and column in range

excel "vba" match last value

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.