Hi,

I have a code that exports certain ranges to text file but the format is little bit tricky. Here is the idea:

Colum1 Colum2 Column3 Column4
Value 1 Value 1 Value 1 Value 1
Value 1 Value 1 Value 1 Value 1
Value 1 Value 1 Value 1 Value 1
Value 1 Value 1 Value 1 Value 1

I have following code:

txt1 = txt1 & vbCrLf & Join(.Transpose(.Transpose(myRecord.Resize(, 8).Value)), vbTab)
        txt2 = txt2 & vbCrLf & Join(.Transpose(.Transpose(myRecord.Offset(, 8).Resize(, 16).Value)), vbTab)
        txt3 = txt3 & vbCrLf & Join(.Transpose(.Transpose(myRecord.Offset(, 24).Resize(, 8).Value)), vbTab)
        txt4 = txt4 & vbCrLf & Join(.Transpose(.Transpose(myRecord.Offset(, 32).Resize(, 5).Value)), vbTab)
This code exports first few columns and then adds remaining columns but below the first two. Formatted that way they are written to text file.

I would like to alter this code in some way that one column (2 for example) is skipped when the remaining are written to text file. More importantly I want to keep the same format as above without putting
last two columns below first two. Simply said nothing should change except to skip Column 2 when writing to text file.

Please help me with this. It is quite urgent.

Thanks!!!