Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Delecting Rows
Does anyone know how to code this
I need to delete a bunch of rows but, the number of rows changes all the time. I need to figure out a way to determine the number of rows that needs to be deleted and delete them, at the same time shifting the other rows up. All this has to be done by clicking a button. Is there a o replace the 5 annd the 7 with variables representing numbers? or is there any other way to accomplish the same task? Any help will be greatly appreciated. Thank you. Ayo Worksheets(1).Rows("5: 7").Select Selection.Delete Shift:=xlUp |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Enabling option „Format rows“ to hide/unhide rows using VBA-code? | Excel Discussion (Misc queries) | |||
Counting characters in multiple rows when rows meet specific criteria | Excel Worksheet Functions | |||
Copy rows of data (eliminating blank rows) from fixed layout | Excel Discussion (Misc queries) | |||
Excel 2003 -Rows hidden. Scrolling unhides rows ! How do I stop th | Excel Discussion (Misc queries) | |||
Pivot Tables: How do I show ALL field rows, including empty rows?? | Excel Worksheet Functions |