Looping vlookup,If,clean cell contens VSA

Hello,
I need some help on using vlookup looping to find text strings in column A that have text string
more than 6 chracters across the cells in column B abd C in the same row.

Example: A1 has text more than 6 chracters, cell B1 and C1 bloking the text. Both cells seems are
empty but some reason they blcok it. These two cells (result from VBA copy&paste)I copy from
another workbook to this worksheet. When I hit a delete key on both B1 and C1, then a full text
would show. There must be something in empty cells in B1 and C1.

More details are in the attached worksheet.

Please advise,
Thanks

This will clean up all the "Blocked" cells in columns B and C.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Hello,
Both VABs work. When I try my actual worksheet,I have two rows of long text in row 1 and 2.
Then texts in the orginal column A, B C shoudl be shift to the right by one column. So A1 should be
in B3, B1 to C3, C1 to D3.

Text in row 1 and 2 should not be chopped off. I hand type the text in A1 and A2, there is no
issue of across cells in column B, C and D.

Can you please revise. Also can you please provide another version which is automatic to "clear contents"
without select marco name and run. I will try to place your VBA into another VBA liked this ...
Will this work?


Private Sub Worksheet_Change(ByVal Target As Range)

Existing VBA for "clear button"
Your VBA "Clear contents"

End Sub

Thanks again

Hello,
I solve the problem by reviewing the codes, then I changed.

Please Login or Register  to view this content.

Thanks