| Home |
| Search |
| Today's Posts |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Variable rows
Thank you very much.
"Rick Rothstein" wrote: Whoops! I forgot the EntireRow part... ActiveCell.Resize(V).EntireRow.Select -- Rick (MVP - Excel) "Rick Rothstein" wrote in message ... I would use this instead of the complex statement you are using... Rws = 58 ActiveCell.Resize(Rws).Select where I used a variable named Rws to hold the number of rows down from the active cell to select. -- Rick (MVP - Excel) "Jwil" wrote in message ... 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
