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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Delete rows but keep formatting to 1000
--One way is to clearcontents rather than deleting the row. But you will have
to clearcontents for the cells without formulas and end of the macro you will need to sort the range to bring the records together --Another way is to recreate or copy the formats using pastespecial and fill formulas into new rows to keep that to 1000. If this post helps click Yes --------------- Jacob Skaria "Jock" wrote: 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Delete rows but keep formatting to 1000
Hi Jock
How does the macro 'remove' rows? If you use Cut/Paste, then you can just use Copy/Paste and then use ..ClearContents to clear data afterwards. Post your macro for further help. Regards, Per "Jock" skrev i meddelelsen ... 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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Delete rows but keep formatting to 1000
Copy and paste wiith subsequent clear contents for souce range will save the
format, but not the formulas. The formulas will have to be re-done if you want them in their original locations. But you could have a macro that does that for you. "Jock" wrote in message ... 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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Delete rows but keep formatting to 1000
It might help if you showed us your code (at minimum, the part that test the
criteria and "removes" the entire row). -- Rick (MVP - Excel) "Jock" wrote in message ... 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 |
Reply |
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 |