Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I will be as brief as possible.
The worksheet was created using the text to columns wizard. The data was originally in Word format. I successfully placed all the data in applicable columns and ran a macro to delete all empty rows remaining from the conversion from Word to Excel. What remains in the worksheet is the page headers from it's Word format. The headers appear at every 21st row, consuming 7 rows. To be completely sure that all of the unwanted text is deleted, as the worksheet will be hundreds of pages, can a macro be created that will delete exactly what text I specify. I would ask this assuming that the row sequence is broken futher down in the document (but I don't think that is the case). Either way, I am looking for the macro that will delete specific rows in sequence or specific text. Any macro will do. I just need them to disappear! Thanks, Bob |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to XML Map Repeating Rows? | Excel Discussion (Misc queries) | |||
Fill in Column with a series of repeating numbers | Excel Worksheet Functions | |||
Repeating Rows at top | Excel Worksheet Functions | |||
deleting a cell from series , why the series gets disturbed? | Excel Worksheet Functions | |||
Charts switch from 'Series in Rows' to 'Series in Columns' | Charts and Charting in Excel |