Hi
Well you could just continue with the structure of the
where ? is the column that gets the fixed variable and "??" is the column that contains it.![]()
outsh.cells(outrow,?).value = cells(i,"??").value
However, if you have a block of fixed variables that are in contiguous cells, then you may be able to transfer / copy a block of cells more easily. Can you give a more detailed example of your entire structure and what has to be copied.
rylo
Bookmarks