| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Delete rows but keep formatting to 1000
A worksheet has 1000 formatted rows some of which contain formulae.
A macro will remove entire rows when certain criteria is met and paste to a different sheet. When this happens, the number of formatted rows decreases in number by the same amount that have been moved. How can I ensure that I always have 1000 rows regardless of how many rows are removed? -- Traa Dy Liooar Jock |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy Top 10 conditional formatting down 1000+ rows | Excel Worksheet Functions | |||
| Custom Formatting (# x 1000) | Excel Discussion (Misc queries) | |||
| How can I use conditional formatting to hide or delete rows? | Excel Worksheet Functions | |||
| Macro to keep 15 specific records and delete 1000 other rows. | Excel Programming | |||
| Find the nearest point to 1000 rows where "amounts" balance and apply special formatting to that row | Excel Programming | |||
Threaded Mode
