Hiding rows with values greater than a reference cell

[jjohn98]

Hello, I have a spreadsheet containing multiple columns. Column A has a header in cell A1 called RR and values in cells A2 to A53 e.g. A2 =200001, A3 = 200002, A4 = 200003 etc. I would like to hide the rows in Column A if they have a value that is greater than the number found in Cell B2 (= 200040). What is the best code to use here?

 

[alansidman]

You can filter the data in Column A by selecting "less than x" when you have auto filter set for your columns of data