| Home |
| Search |
| Today's Posts |
|
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
Add/Delete rows based on count
Thank you - almost perfect. Have come across 2 minor glitches. First on I fixed myself: Code ------------------- 'add rows Do Until dRows = 23 ActiveCell.Offset(dRows + 1, 0).EntireRow.Inser ------------------- The dRows +1 needed to be just dRows or it added the rows between th name and starts. The second glitch has me beat. It only affects the last block of data No matter how many rows of data are in the last set of records, al actions are performed above the last row. So if there are no data rows rows are added between the name and starts row. If there are data row then rows are added/deleted above the last row. Not a real problem if there's more than 20 rows to work with, but no good with less than 20 rows. I've tried to figure it out myself bu just don't have the knowledge. Any fix would be great -- Mark ----------------------------------------------------------------------- Mark K's Profile: http://www.excelforum.com/member.php...fo&userid=1411 View this thread: http://www.excelforum.com/showthread.php?threadid=57324 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| If Count is not in a certain range, delete Rows | Excel Discussion (Misc queries) | |||
| Delete Rows based on condition | Excel Discussion (Misc queries) | |||
| Delete Rows based on value | Excel Worksheet Functions | |||
| Delete rows based on Cell name | Excel Programming | |||
| Delete Rows Based On Content | Excel Programming | |||
![Mark K[_15_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
