I have been looking for a sub that can find a cell in column A that ha
a "-" in it the actuall cell will contain "P-9999999" the only thin
consistant is the "-". When it finds the cell I need it to shift 1
cells to the Right.
Thanks for the help or any ideas,
Bo

--
robertjtucke
-----------------------------------------------------------------------
robertjtucker's Profile: http://www.excelforum.com/member.php...fo&userid=2180
View this thread: http://www.excelforum.com/showthread.php?threadid=38933