Thread: Selecting rows
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
JT[_2_] JT[_2_] is offline
external usenet poster
 
Posts: 96
Default 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.