Results 1 to 5 of 5

Thread: Suppress Row in Excel based on a condition

Threaded View

  1. Jun 26th, 2006, 04:08 AM #1
    TheBionicOrange
    TheBionicOrange is offline

    Thread Starter
    Frenzied Member TheBionicOrange's Avatar
    Join Date
    Apr 2001
    Location
    Cardiff, UK
    Posts
    1,818

    Resolved Suppress Row in Excel based on a condition

    If I had 10 rows of data, and say Column F had either "Y" or "N" in it, what would be the best way to toggle whether I saw rows with a "Y" in that column or not ?

    At the moment I have a checkbox, and if its selected I am reading the value of that column a row at a time using the Offset command, and I am now looking for some kind of row suppress command. I suppose I could just set the RowHeight property to 0.

    Is this the best way to do this ?

    I know reading row by row and using the offset command can be quite slow, and I don't know the volume of data I will be dealing with yet.

    Any suggestions ?
    Last edited by TheBionicOrange; Jun 27th, 2006 at 02:28 AM.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width