Excel workbook Hide Rows - VBA

Jparra12

Hello,

 

I would like to know the best way to hide all rows based on specific criteria. The Criteria is:

 

In row 14 column B it asks the question (how many compressors?) in column C of same row is where the value is input (2)

 

in Cell range B25-34 i have a list of compressors 1-10.

 

if the number of compressors is 2 (cell C14) i want to hide 8 of the 10 rows.

 

Any help would be appreciated.

 

Josh

uday_guntupalli

@Jparra12, 
      Can you elaborate a little - based on your tags it looks like you are trying to acheive what you want in VBA and has no relation to JMP ? If that is correct, you might find help faster on a VBA forum . 

      In case I misread your question and you are trying to hide rows in JMP , the following will work : 

// Open Sample Data
dt = Open( "$SAMPLE_DATA/Cities.jmp" );

// Select Rows that match a condition 
dt << Select Where(:city == "HOUSTON") ; 

// Hide and Exclude Rows 
dt << Hide and Exclude ; 

// Instead if you want to delete the rows 
Wait(0.5); // For demonstrative purposes only 

dt << Delete Rows; 

This can be edited and adapted to apply conditions based on information captured through a UI or a specific cell in your table