+ Reply to Thread
Results 1 to 1 of 1

Macro to look at part content of a cell and Hide row

  1. #1
    Registered User
    Join Date
    03-25-2010
    Location
    London, England
    MS-Off Ver
    Excel 2007
    Posts
    44

    Macro to look at part content of a cell and Hide row

    Hi,

    I have a small piece of code that goes down a sheet and looks at the content of the cell in column A. Some cells will begin with the string WK21GT01- the rows that these cells are in I want to Hide.

    I have a small macro that works for a full string as :-

    Please Login or Register  to view this content.
    This works fine where a cell contains the specific string, but after the dash in the WK21GT01- string there are a number of different possibilities, so I just need to Hide all rows where the cell in Column "A" contains part string "WK21GT01-".

    Your help is appreciated.

    Regards
    Last edited by Macca_GB; 11-21-2012 at 10:09 AM. Reason: Added code tags

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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