In my workbook there are several work sheets are available and I want to save
the each worksheets B COLUMN CELL CONTENTS in a SEPARATE NOTEPAD FILES with
the SHEET NAMES AS FILE NAME.

For example in sheet1 the B COLUM cell contents should be exported as a
notepad file with the sheet name as file name in my desktop and like that it
should export the remaining sheets B column contents in a separate separate
notepad files and it should automatically save the files in my desk top when
I run a macro.

At the same time the note pad file should be generated by way of selecting
the start to end of the cell contents in b column and there will not be any
blank cell in between the B column range. So the macro should export only
the cells which are having the content continuously in B column.

If, anyone knows it, then please provide the VB code for the same and thanks
in advance.

TGV