i'm trying to do a macro that goes trough a table and copy the data in 1st row into a string and write in a csv file
but the table does not have always the same number of colums and i need it to check if next colum is blank or not.
then i need the same thing but to copy the data from the nr rows with data and for the nr of colums it detected
hope its not too confusing
i have a table with headers in the first row and data on the next rows but not the colums or the rows have a fixed nr and wath i need is some way to copy the data to a csv format (~ for fields indicator) first the headers (1 row) then the data