I have a small problem with one line of code.

Do While ActiveCell.Row < rw


It is part of a loop that works but I need it to use the active cell
from a certain sheet (Carriage). I have tried it as below but it doesnt
work. Think this is just a basic code error but can't work it out.

Do While Sheets("Carriage").ActiveCell.Row < rw

Thanks.

James


--
fugfug
------------------------------------------------------------------------
fugfug's Profile: http://www.excelforum.com/member.php...o&userid=24950
View this thread: http://www.excelforum.com/showthread...hreadid=389017