Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Please help - I need a macro to clean up a worksheet
Look for in column "A" the word "Created:" then when it is located (even with the whole string) it will delete the whole cell Column A 1 Orig ER: Emilio N. Francisco (emilioef) 2 Created: 1/6/2008 6:45:00 AM Scheduled: Yes 3 Eff Date: 01/08/2008 Conf#: 1G5863K App: CLKCCM 4 Recipient: SHIRLEY HEPBURN (4045656) Send Prenote: No 5 SHIRLEY HEPBURN 6 Orig CR: Emilio N. Francisco (emilioef) 7 Created: 1/7/2008 6:44:00 AM Scheduled: No 8 Eff Date: 01/08/2008 Conf#: 1G5861B App: CLKCCM 9 Recipient: DOUGLAS ANDERSON (4043211) Send Prenote: Yes 10 DOUGLAS ANDERSON 11 Orig BR: Emilio N. Francisco (emilioef) 12 Created: 1/5/2008 6:52:00 AM Scheduled: Yes 13 Eff Date: 01/08/2008 Conf#: 1G5862L App: CLKCCM 14 Recipient: JOHN ZALESKY (100274) Send Prenote: No 15 JOHN ZALESKY Any help would be appreciated. Chuong Nguyen |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Delete rows with specific text | New Users to Excel | |||
Delete Rows Without Specific Text | Excel Worksheet Functions | |||
macro to select cells containing specific text and delete all cells but these | Excel Programming | |||
Delete specific cells contents in a row with some locked cells in the same row | Excel Programming | |||
Run Specific Marco | Excel Programming |