With ActiveSheet
LastRow = .UsedRange.Rows.Count
.Range(.Cells(FirstRow, 1), .Cells(LastRow, 1)).EntireRow.Select
End With
This line performs the tasks that it is asked but it erases other values
contained in a combobox in another workbook.
With ActiveSheet
LastRow = .UsedRange.Rows.Count
.Range(.Cells(FirstRow, 1), .Cells(LastRow, 1)).EntireRow.Select
End With
This line performs the tasks that it is asked but it erases other values
contained in a combobox in another workbook.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks