Forum Discussion
Convert 912 rows and 16 columns into 2 columns....with a twist
You may open the file, Data->Query and Connections, on the right pane double click on query (or Edit from right click menu), query editor will be opened, here you will see the steps
I'm testing the macro and it's repeating colours and shuffling the order for some reason.
Do you have any idea what might cause that? I've attached the files for reference.
Maybe you have changed selection when macro is running ? It is only way that I can think
could cause the behaviour you described. Run macro only once and do not interrupt it when
it runs. I made a video, it shows you how macro proceeds...
but video format is not allowed to send here.
You can run any macro step by step using F8 function key.
Function key F5 runs macro to the end if there is no stopping points in code.
I added one row as an comment to code. If you take comment-mark away and run macro
after that it works much faster without updating screen while working.
It is fine feature with macros that a person can make them work in so many ways. Implementation or
the way to archieve the goal depends on person who makes the code and his imagination.