+ Reply to Thread
Results 1 to 3 of 3

Range of Rows filtered by column data

  1. #1
    Registered User
    Join Date
    07-19-2016
    Location
    Berlin
    MS-Off Ver
    2016
    Posts
    3

    Question Range of Rows filtered by column data

    Hey nice people, I would be really thankful if somebody could help me with this issue:

    Is there a way to define a range that consists only of the rows that in some column contain certain data?

    Example:

    Let's say I have in Column A the categories Cat1 and Cat2
    Can I set a range that contains all the rows that have on the column A the text Cat1?

    I am sorry I currently have no vba code to post... If I do before i get an answer I am going to post it.

    Thanks a lot in advance.

    V.

  2. #2
    Forum Expert
    Join Date
    12-24-2007
    Location
    Alsace - France
    MS-Off Ver
    MS 365 Office Suite
    Posts
    5,066

    Re: Range of Rows filtered by column data

    Did you see the use of filter ?
    What do you want to do with this range?
    - Battle without fear gives no glory - Just try

  3. #3
    Forum Expert
    Join Date
    12-24-2007
    Location
    Alsace - France
    MS-Off Ver
    MS 365 Office Suite
    Posts
    5,066

    Re: Range of Rows filtered by column data

    Perhaps see next code:
    WkRg is range concerned
    Please Login or Register  to view this content.

+ 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] looping in filtered range by rows
    By HarryKlein in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 06-16-2016, 09:19 AM
  2. Data validation list, created from a filtered table range/column
    By Confuselocated in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-04-2014, 11:28 AM
  3. [SOLVED] Count of visible rows in a filtered range
    By brucemc777 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-16-2014, 01:17 PM
  4. Count rows of a filtered range
    By newbi004 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-29-2013, 06:30 AM
  5. Replies: 4
    Last Post: 08-16-2012, 06:20 PM
  6. [SOLVED] Copy first 4 rows of filtered range
    By Charles in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 04-22-2012, 03:02 PM
  7. Define a range containing the first 10 rows of a filtered list
    By Marco in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-07-2005, 09:05 AM

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