View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Ron de Bruin Ron de Bruin is offline
external usenet poster
 
Posts: 11,123
Default Select case and Last Cell Problem

One letter or a A,B, C or ?

--
Regards Ron De Bruin
http://www.rondebruin.nl



"JamesBurrows" wrote in message
news:JamesBurrows.28xqjm_1149521103.2085@excelforu m-nospam.com...

Thanks for that Ron the only thing is there are some rows with data in
that I dont want to copy I only want to copy the lines across that have
a letter in them, some have a few words in


--
JamesBurrows
------------------------------------------------------------------------
JamesBurrows's Profile: http://www.excelforum.com/member.php...o&userid=35101
View this thread: http://www.excelforum.com/showthread...hreadid=548559