I have spreadsheet VBA that does the following in another spreadsheet:
* User selects CSV
* Files is transferred to an array (1 column), before parsing
* Files is imported, parsed and formatted on tab 1
* Array is searched for user-defined strings, keeping rows
* Array is then imported, parsed and formatted on tab 2
* Pivot table is created and formatted on tab 3 from tab 2
* Tab 2 worksheet is rearranged on tab 4, column by column, e.g. the
originating spreadsheet tells it which columns should go in which
order
The last stage is the problem area. The order of columns is defined by
the macro, but because the copying fails on some cells. Initially, the
code rearranged the spreadsheet cells by cell, but some very long,
multi-rowed cells, where a user has inserted Alt+Enter, were copied
with # value instead of the real value. I am unable to get my code to
copy whole columns. I have also tried to strip out what are linefeeds,
but causes problems in other cells.
Bookmarks