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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Variable rows
Sub AircodeSampleWarning MyUserinput = Inputbox("Please enter a number") ActiveCell.Offset(0, 0).Rows("1:" & MyUserInput).EntireRow.Select End Sub You may want to consider checking the user input to make sure that it is a valid entry before executing your selection. If they enter "sfghsg" the code will error out when trying to select that range. I could also see the rare but unfortunate instance where a user meant to type "9" but accidently hits the key twice and deletes 99 rows. Perhaps consider selecting the rows, then give the user a chance to abort if they were to hasty and mis-entered their number of rows to delete... HTH Keith "Jwil" wrote: 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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Variable rows
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. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Variable rows
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. |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Variable rows
Thanks a lot.
"ker_01" wrote: Sub AircodeSampleWarning MyUserinput = Inputbox("Please enter a number") ActiveCell.Offset(0, 0).Rows("1:" & MyUserInput).EntireRow.Select End Sub You may want to consider checking the user input to make sure that it is a valid entry before executing your selection. If they enter "sfghsg" the code will error out when trying to select that range. I could also see the rare but unfortunate instance where a user meant to type "9" but accidently hits the key twice and deletes 99 rows. Perhaps consider selecting the rows, then give the user a chance to abort if they were to hasty and mis-entered their number of rows to delete... HTH Keith "Jwil" wrote: 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. |
#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. |
Reply |
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 |