It should work. Just make sure you have the whole line on there right
(pasting code on here sometimes breaks the lines at weird spaces. That
entire line ends with the "then".

I've never seen anyone unable to run the instr or ucase functions.

Did you rename the variables to match your workbook? i.e "sourcetab"
and "desttab" etc.
TonyG001 wrote:
thanks Jamie but the macro is stopping at
If InStr(UCase(Sheets(SourceTab).Cells(x, "B")),

any suggestions?


--
TonyG001
------------------------------------------------------------------------
TonyG001's Profile: http://www.excelforum.com/member.php...o&userid=35737
View this thread: http://www.excelforum.com/showthread...hreadid=555185