GeminiHZH

The trick is to use & to get the Range. Sub HideRows() ' ' HideRows Macro '     Dim FoundCellS As Excel.Range     Dim FoundCellE As Excel.Range     Dim iRowS As Integer     Dim iRowE As Integer               Set FoundCellS = Range("sheetname!A:A").Find(what:="string1", lookat:=xlWhole)     Set FoundCellE = Range("sheetname!A:A").Find(what:="string2", lookat:=xlWhole)     iRowS = FoundCellS.Row     iRowE = FoundCellE.Row               For Each c In Worksheets("DailyReport").Range( "B" & iRowS & ":B" & iRowE )         If c.Value < 10 And c.Value <> "" Then Rows(c.Row).EntireRow.Hidden = True     Next      End Sub

There are totally 3 ways to hide specific rows based on dimensions columns and expression column, which are created in "Expression" tab) in Qlikview. If you need to hide the rows based on the dimensions. 1.  You can use "Enable Conditional" in the Dimensions Tab, and then use expressions to select dimensions. The tricky part is to hide the rows based on Expression columns, as Qlikview are not designed to do such job. BUT , we can do it by using expressions. Expression is such a beautiful  thing in Qlikview. 2. Use the "Dimension Limit" tab, where can show top N / N% of a table based on the first expression column. Then we see the limitation, this is only available for the first expression column. 3. Use the expression in one of the expression column and variables. We use  expression_column1 as an example here. The expressions for all the columns are originally like below: For example, expression_column1 =  expression1 , and expression_column2...