| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Selecting rows with variable
Im trying to select, then delete a whole lod of rows in
one go. Im trying to use the following commands: Rows("4:" & count_y ).Select Selection.Delete Shift:=xlUp It doesn't like this at all. How can I get it to do what I want? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Selecting rows with variable
try this
count_y=20 Rows("4:" & count_y ).entirerow.delete "Jim" wrote in message ... Im trying to select, then delete a whole lod of rows in one go. Im trying to use the following commands: Rows("4:" & count_y ).Select Selection.Delete Shift:=xlUp It doesn't like this at all. How can I get it to do what I want? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Selecting rows with variable
Jim
Sub TestDeleteRows() Dim RowCounter As Long RowCounter = 10 Rows("4:" & RowCounter).EntireRow.Delete End Sub works for me Regards Trevor "Jim" wrote in message ... Im trying to select, then delete a whole lod of rows in one go. Im trying to use the following commands: Rows("4:" & count_y ).Select Selection.Delete Shift:=xlUp It doesn't like this at all. How can I get it to do what I want? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find a single value from tables by selecting two variable inputs? | Excel Worksheet Functions | |||
| Selecting a variable print area in a macro | Excel Discussion (Misc queries) | |||
| macro syntax for selecting variable range | Excel Discussion (Misc queries) | |||
| Selecting Variable Data Ranges | Excel Discussion (Misc queries) | |||
| after selecting 50 rows of a column i can't reference the cells in the rows | New Users to Excel | |||
![Jim[_24_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
