I tried executing RB Smissaert's suggested macro and I got a compil
error:

Set rngLast = _
Application.InputBox(Prompt:="Choose the last cell of the range to


Does anyone knowhow I can fix it?

Thank you in advance

--
luu98
-----------------------------------------------------------------------
luu980's Profile: http://www.excelforum.com/member.php...nfo&userid=693
View this thread: http://www.excelforum.com/showthread.php?threadid=52037