+ Reply to Thread
Results 1 to 6 of 6

Looping vlookup,If,clean cell contens VSA

  1. #1
    Forum Contributor
    Join Date
    10-03-2012
    Location
    USA
    MS-Off Ver
    2010
    Posts
    496

    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
    Last edited by Rocky2013; 08-11-2013 at 09:46 PM.

  2. #2
    Forum Guru
    Join Date
    07-25-2011
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    9,596

    Re: Looping vlookup,If,clean cell contens VSA

    This will clean up all the "Blocked" cells in columns B and C.
    Please Login or Register  to view this content.
    Last edited by AlphaFrog; 08-08-2013 at 09:43 PM.
    Surround your VBA code with CODE tags e.g.;
    [CODE]your VBA code here[/CODE]
    The # button in the forum editor will apply CODE tags around your selected text.

  3. #3
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 365 Win 11 Home 64 Bit
    Posts
    21,253

    Re: Looping vlookup,If,clean cell contens VSA

    Please Login or Register  to view this content.
    Alan


    Have you debugged your code?
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  4. #4
    Forum Contributor
    Join Date
    10-03-2012
    Location
    USA
    MS-Off Ver
    2010
    Posts
    496

    Re: Looping vlookup,If,clean cell contens VSA

    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
    Last edited by Rocky2013; 08-09-2013 at 12:25 PM.

  5. #5
    Forum Contributor
    Join Date
    10-03-2012
    Location
    USA
    MS-Off Ver
    2010
    Posts
    496

    Re: Looping vlookup,If,clean cell contens VSA

    Please! Thanks

  6. #6
    Forum Contributor
    Join Date
    10-03-2012
    Location
    USA
    MS-Off Ver
    2010
    Posts
    496

    Re: Looping vlookup,If,clean cell contens VSA

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

    Please Login or Register  to view this content.

    Thanks
    Last edited by Rocky2013; 08-11-2013 at 09:46 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] few more lines of code to move cell contens to new range.
    By cdafonseca in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 05-07-2013, 09:30 PM
  2. Replies: 1
    Last Post: 08-24-2012, 11:35 AM
  3. [SOLVED] VBA Code to optimize and clean data- clean out numerical/ or symbol
    By tracylsr in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-05-2012, 04:21 PM
  4. Clean function combined with VLOOKUP
    By Nathalie1974 in forum Excel General
    Replies: 3
    Last Post: 02-23-2012, 07:53 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1