I figured another way to do it also. But I cant figure out how to initialize the location of a cell. If I can get the value of X recorded as the location (D4 for example it would work perfectly. there must be a function of some sort?? This is what I have
any ideas



objsheet.range("A1").end(xlDown).select

x = ??????(cell location)

objsheet.RANGE(ALLTRIM(X)).End(xlToRight).SELECT