macro to find and clear unwanted Items

**Howardc1001** · 08-20-2021, 06:59 AM

I have data that is imported on sheet "Imported Data"

I need to find and clear text containing "for the year ended" in Col A as well as any text 2 rows below this

i have written code to do this but it is not clear the text above

Please Login or Register  to view this content.

It would be appreciated if someone could kindly amend my code

**jindon** · 08-20-2021, 07:29 AM

Please Login or Register  to view this content.

Please Login or Register  to view this content.

**Howardc1001** · 08-20-2021, 08:26 AM

Thanks for the Help. Code works perfectly

macro to find and clear unwanted Items

LinkBack

Thread Tools

Rate This Thread

Display

macro to find and clear unwanted Items

Re: macro to find and clear unwanted Items

Re: macro to find and clear unwanted Items

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Macro to clear CF in Col B and copy non CF items

[SOLVED] Macro to clear Fill Coloured items only from row 9 in Col E

[SOLVED] Macro to delete unwanted items in a Column

[SOLVED] Macro to delete unwanted items

[SOLVED] Macro to clear specific Items

Help require to clear unwanted characters from the end

unwanted line space - how do I clear it??

Bookmarks

Bookmarks

Posting Permissions