I have a code that crashes my excel, it takes the data from one sheet and transforms it from a tabular view to vertical. I believe it is slow because it is taking it from a database view to over 45k rows.
does anyone have any tips for optimizing this code? I need to avoid writing cell by cell...