Jason,
If you use Cell(n,n) instead of Range("A1"), it is easier to manipulate the row and columns. (D4 would be .Cell(4,4))
>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