How to search a column with keywords and write decimal value in to a row

Yes mate it is working

Your NO 1

Many * 10000*10000= Thanks

Originally Posted by davesexcel

Stop changing the code! I have it at B65536 for a reason, so the code will find the very last cell in the column.