Iam using
ACTIVESHEET.CELLS.SPECIALCELLS(XLCELLTYPELASTCELL) .ACTIVATE
ACTIVECELL.ENTIREROW.CELLS(1, \"A\").SELECT
to get to the last cell used and then take it to column A. The problem

that I am having is, if I go down the worksheet and enter in text, and
then delete it. It will still go to where the text was that I
deleted.
So I guess what I am asking is if there is something that I could use
to find the last cell with text,instead of just the last cell used?


--
jj33002
------------------------------------------------------------------------
jj33002's Profile: http://www.excelforum.com/member.php...o&userid=30020
View this thread: http://www.excelforum.com/showthread...hreadid=497110