I am trying to use a variable in a range of cells. IE Range(a2:z100).select... I would like to set something like MyRange=1000 and set use Range(a2:Myrange).select. that way when MyRange changes i can make 1 change in the Macro and still have it run like i want.