VBA help needed to find text string, clear cells then add new cell value

**krjoshi** · 03-13-2014, 07:49 AM

Folks,

Please help me to build a Macro to search text string "WorkPack Approval:" in Column A, then clear all contents from cell contains text string "WorkPack Approval:" to just above text string "Comments:". And add new cell value in the same cell as "LOG BOOK:"

I have attached the work book of what I am trying to accomplish.

Thanks in advance for your time and expertise

**StephenR** · 03-13-2014, 08:10 AM

Try this, but those merged cells are horrible:

Please Login or Register  to view this content.

**ragulduy** · 03-13-2014, 08:11 AM

Please Login or Register  to view this content.

?

**krjoshi** · 03-13-2014, 11:29 AM

Hi Stephen & ragulduy,

Thanks you so much gents. Your code is working excellent.

Joshi

VBA help needed to find text string, clear cells then add new cell value

LinkBack

Thread Tools

Rate This Thread

Display

VBA help needed to find text string, clear cells then add new cell value

Re: VBA help needed to find text string, clear cells then add new cell value

Re: VBA help needed to find text string, clear cells then add new cell value

Re: VBA help needed to find text string, clear cells then add new cell value

Thread Information

Users Browsing this Thread

Similar Threads

if column equals text string clear cells

[SOLVED] Find partial text string within another text string return original text into cell.

[SOLVED] VBA Needed to find number/text within cell string and copy out to new cell

Find Text String in Range of Cells

Macro to find bold cells then clear adjacent cell

Bookmarks

Bookmarks

Posting Permissions