Consider blank cells as delimiter when exporting excel sheet to text file

Hi all,

I am busy with a excel workbook which calculates data, using input parameters via a userform, for pipeline installation fatigue.
Part of the userform is to export the results to a text file so these can be incorporated into a document.
I have the code working for exporting the data to a text file, but for some reason the code does not consider blank cells as delimiter.
The result is that the textfile is presenting the data at the wrong location, which makes it difficult to read without manually including tabs.

Example of text is included as attachment

The code is as follows:

Button to call instruction

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Could someone help me solving this problem?

Thanx,
Martijn

@Martijn79

Welkom to the forum.

I can't help you with you problem.

But please add your code between tags (#), according to the forumrules.

I read a simular question, recently, before.

If it was yours, please also add a link to that forum, so forummember can take a look at the already given solutions.