Exporting formulated data to text file

[tonywoods]

A novice in excel and a novice to this site,hey there.
Ok so i've created a spreadsheet which contains just one macro(using VB) and five formulated columns. Both systems are on the same sheet and are just highlighting errors. What i need to do is create a single output text file that will contain all the errors highlighted in the spreadsheet. Desperately in need of help....

 

[Joe4]

Do you realize that you posted this question to the Access page of this site? You may want to try re-posting to the Excel page.

In any event, I think when you create text files, you pretty much lose the formatting characteristics, so I am unsure how you can create a text file with certain sections highlighted.