Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Selecting rows
I want to select rows. However, the first row will always
be different, so I am trying to use a variable. Here is the code that is not working: Dim vlastrow As Integer vlastrow = Cells.SpecialCells(xlCellTypeLastCell).Row FIRSTROW = vlastrow + 1 Rows((FIRSTROW), "65000").EntireRow.Select Any suggestions would be appreciated. Thanks for the help. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Selecting rows
Hi JT,
Try: Sub Tester03() Dim FirstRow As Long FirstRow = Cells.SpecialCells(xlCellTypeLastCell).Row + 1 Rows(FirstRow).Resize(Rows.Count - FirstRow + 1).Select End Sub Note that it is rarely necessary to make physical range selections. --- Regards, Norman "JT" wrote in message ... I want to select rows. However, the first row will always be different, so I am trying to use a variable. Here is the code that is not working: Dim vlastrow As Integer vlastrow = Cells.SpecialCells(xlCellTypeLastCell).Row FIRSTROW = vlastrow + 1 Rows((FIRSTROW), "65000").EntireRow.Select Any suggestions would be appreciated. Thanks for the help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
after selecting 50 rows of a column i can't reference the cells in the rows | New Users to Excel | |||
Selecting Rows | Excel Worksheet Functions | |||
Selecting one every four other rows | Excel Programming | |||
Selecting rows | Excel Programming | |||
Selecting Rows | Excel Programming |