Display rows where value > 100

Hi, i have this code below but i would like to only display rows where value in column E is > 100. Only display rows that are in red...Thanks

Please Login or Register  to view this content.

Breakdown Total
A 1152
B 17
C 0
D 21
E 139

Please Login or Register  to view this content.

Originally Posted by stnkynts

Please Login or Register  to view this content.

hi stnkynts
getting error message "Syntax Error"

Please Login or Register  to view this content.

Originally Posted by stnkynts

Please Login or Register  to view this content.

hi stnkynts
getting error message "Syntax Error"

Please Login or Register  to view this content.

Please Login or Register  to view this content.

I did not tell you to set the range. Run the code I provided as written and let me know if that meets your requirements.