Horje
excel vba last row in range Code Example
excel vba last row in 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 resized / moved)
Set rDuplicate = Range(Cells(lFirstRow, lFirstColumn), _
      Cells(lLastRow, lLastColumn))



3

Related
regex numeric digits Code Example regex numeric digits Code Example
excel vba last row Code Example excel vba last row Code Example
xlvba double quotes in string literal Code Example xlvba double quotes in string literal Code Example
excel formula how to create strings containing double quotes Code Example excel formula how to create strings containing double quotes Code Example
vba how to convert a column number into an Excel column Code Example vba how to convert a column number into an Excel column Code Example

Type:
 Code Example
Category:
 Coding
Sub Category:
 Code Example
Uploaded by:
 Admin
Views:
 9



 

Horje