+ Reply to Thread
Results 1 to 5 of 5

hidding rows with checkboxes and coping visible rows to another sheet

  1. #1
    Registered User
    Join Date
    10-15-2008
    Location
    Lithuania
    Posts
    28

    hidding rows with checkboxes and coping visible rows to another sheet

    Hello,

    i'm new to this, so any help would be more than appreciated

    Here is my problem:
    1. I have to hide rows using checkboxes
    2. I have to copy visible rows (not marked ones) to another sheet in the same workbook.

    So far i have managet to creat this code for hiding/sowing rows:
    Please Login or Register  to view this content.
    Well it works (to my surprise), but not very correctly - some checkboxes if checked hide the rows and others hide rows if not checked.

    Another thing about copying to another sheet is this, that the code will copy all the rows, but i need only specific rows which difers every time i check the checkboxes. I tried doing a button that would do this and the code is this:

    Please Login or Register  to view this content.
    SO PLEASE HEEELP ME TO DO THIS
    Last edited by royUK; 10-15-2008 at 09:06 AM.

  2. #2
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200
    Welcome to the Forum. Please take the time to read the Forum Rules & use Code Tags in future.
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

  3. #3
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200
    Your first code can be replaced by

    Please Login or Register  to view this content.
    The second by
    Please Login or Register  to view this content.

  4. #4
    Registered User
    Join Date
    10-15-2008
    Location
    Lithuania
    Posts
    28
    Thank you very much this works just great !

  5. #5
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200
    Thanks for the feedback. Can you now mark the thread Solved

+ 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