Say I have the following variables

myVar1 = 1
myVar2 = Sheet("sheet1").Range("B5")

how do I get myVar2 to equal Sheet("sheet1").Range("C5") using myVar1

also;

how do I get myVar2 to equal Sheet("sheet1").Range("B6") using myVar1

Bruce