+ Reply to Thread
Results 1 to 8 of 8

VBA formating whereever text is found kept in code

  1. #1
    Forum Contributor
    Join Date
    05-01-2013
    Location
    IND
    MS-Off Ver
    Excel 2007
    Posts
    130

    VBA formating whereever text is found kept in code

    Where ever text field name Test Results in column A is found which I will put in my VBA code the data will appear as in C and D.

    Column A Column C Column D
    Test Results
    known description: x112 Test Results1 known description: x112
    known description: x113 Test Results2 known description: x113
    known description: x114 Test Results3 known description: x114
    known description: x115 Test Results4 known description: x115
    known description: x116 Test Results5 known description: x116
    known description: x117 Test Results6 known description: x117

  2. #2
    Forum Expert NeedForExcel's Avatar
    Join Date
    03-16-2013
    Location
    Pune, India
    MS-Off Ver
    Excel 2016:2019, MS 365
    Posts
    3,873

    Re: VBA formating whereever text is found kept in code

    Which data should appear in Column C & D??
    Cheers!
    Deep Dave

  3. #3
    Forum Contributor
    Join Date
    05-01-2013
    Location
    IND
    MS-Off Ver
    Excel 2007
    Posts
    130

    Re: VBA formating whereever text is found kept in code

    Above "Test Results" there are Column A, Column C, Column D. I wrote that just to represent the columns.

  4. #4
    Forum Contributor
    Join Date
    05-01-2013
    Location
    IND
    MS-Off Ver
    Excel 2007
    Posts
    130

    Re: VBA formating whereever text is found kept in code

    Test Results and its below known description data may appear in any column as group. Say it can appear in 1-7 row or 14-20 etc row number.

  5. #5
    Forum Contributor
    Join Date
    05-01-2013
    Location
    IND
    MS-Off Ver
    Excel 2007
    Posts
    130

    Re: VBA formating whereever text is found kept in code

    Please modify this code. This group of data may appear in any group of row.

    Please Login or Register  to view this content.

  6. #6
    Forum Contributor
    Join Date
    05-01-2013
    Location
    IND
    MS-Off Ver
    Excel 2007
    Posts
    130

    Re: VBA formating whereever text is found kept in code

    This group of data may appears together in any group of row.
    I want a VBA code that makes this group row independent that starts with "Cells.Find(What:=" ?
    If Cells.Find(What:= does not exist then let the code exit silently.
    I have the sample code above but I can not make this group data row independent.

  7. #7
    Forum Contributor
    Join Date
    05-01-2013
    Location
    IND
    MS-Off Ver
    Excel 2007
    Posts
    130

    Re: VBA formating whereever text is found kept in code

    still looking for a solution !!!

  8. #8
    Forum Contributor
    Join Date
    05-01-2013
    Location
    IND
    MS-Off Ver
    Excel 2007
    Posts
    130

    Re: VBA formating whereever text is found kept in code

    Still !!!!!!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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