Hi Ervit - thanks very much for this post which has saved me a lot of pain and grief!

I have run into a problem when I run it in Excel - hope you can help.


After pasting logic file in cell A1 (unmerged) and then hitting smiley face to generate questions - I get the following debug error when macro won't run - "target_sheet.UsedRange.Cells.Delete 'clear the target sheet" ??

Can you pls advise what this means / how I might fix it so that the macro will run as intended etc.

Thanks again - Alan

Hi Alan,

It's hard to debug without working with exactly the same data.

Let's try this: before running the "Generate question list" macro, look in the Qlist sheet. If there is anything at all there (for example, an empty formatted table), delete those columns, so that you're left with an empty sheet. Then try running the macro. Please let me know if this helps or not.

Hi Ervit - thanks for getting back to me - and yes this did work !

When I opened the Qlist tab it already had headers in each blank column - Question number; question code; etc. - so I assumed they were supposed to be there - when I deleted them the macro worked a treat!

I am building up some test data in my survey - so haven't checked the rest yet - but I am sure it will be fine.

Thanks again - and if I do run into any more snafus I'll drop you a quick post.

Cheers - Alan

Must have been sloppiness on my part.

The easiest solution would be to add a step to "Clear the Qlist sheet" into the instructions, in case someone else uses this.

Hopefully you won't have other issues.