| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Delete Rows based on # of rows (no variable?) | Excel Programming | |||
| Using variable to select rows | Excel Programming | |||
| sum and variable rows | Excel Worksheet Functions | |||
| How do I sum variable rows in a macro? | Excel Programming | |||
| sum variable # of rows | Excel Programming | |||
Threaded Mode
