Thread: Variable rows
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jwil Jwil is offline
external usenet poster
 
Posts: 7
Default Variable rows

Hello,

How do I use a variable to select entire rows? I want to ask the user how
many rows they want to select and then use that number to select the rows.

For instance:
ActiveCell.Offset(0, 0).Rows("1:58").EntireRow.Select
selects 58 rows. I would like to replace the '58' with a variable so that I
can choose how many I want to delete.