excel vba - how to select dynamic cell based on numeric value -

i looking code selecting cell based on numeric value.

i have constant column name i.e q , dynamic numeric value in a2 cell vary every time 5, 10 or 22.

if a2 contain 5 wanna go q5 if a2 contain 99 wanna go q99 .

i have tried offset not succeed. suggestion welcome.

thanks in advance.

consider:

sub qwerty() if range("a2").value > 0 , range("a2").value < rows.count + 1     range("q" & range("a2").value).select end if end sub