vba - how to use a constant as a range index -

i want use construct

option explicit  public const celllocation string = "5, 7"  ... .  data = range1(celllocation ).value 

my code works data = range1( 5, 7 ).value

but not data = range1( celllocation ).value

how can specify cell location constant

not sure can't use "offset" here.

set celllocation = cells(5,7)