VBA to clear contents of the cell in a column of data in a cell starts with specific word.
Have to clear the contents of all those cells in a coloumn which starts from "Property ID"
Have attached the excel file where data and needed result is mentioned.
Last edited by winmaxservices1; 01-03-2015 at 08:00 AM. Reason: additional information
HI winmax,
You may try this,
Please add my reputation if the above code has solved your problem
Please Login or Register to view this content.
Hi, winmaxservices1,
use the Autofiloter and "Starts with" to filter and delete the rows/entries manually.
As your data shows empty cells next to the searched words you may like to use
Please Login or Register to view this content.Ciao,Please Login or Register to view this content.
Holger
Last edited by HaHoBe; 01-03-2015 at 08:26 AM. Reason: code for both deleting entire row as well as clearing cells
Use Code-Tags for showing your code: [code] Your Code here [/code]
Please mark your question Solved if there has been offered a solution that works fine for you
You may try this..
Please Login or Register to view this content.
Regards
sktneer
Treat people the way you want to be treated. Talk to people the way you want to be talked to.
Respect is earned NOT given.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks