Hi I am new to VBA can someone please help with this. I have scoured through many pages of threads and seen similar queries but my lack of VBA knowledge prevents me adapting some of the other solutions to my needs.

If I record a macro to select a range of rows I get something like this (in part)...
Rows("160:165").Select

I would like the range to be a variable based on cells in the worksheet that I can change, thereby the selected range will change

for example,

if cell A1=160 and cell A2=165 , rows 160 to row 165 would be selected

or

if cell A1=120 and cell A2=135 , rows 120 to row 135 would be selected

thanks