No Cy, I don't know what you mean, that's why I asked the question.
Apparently, your data has one question per row. You failed to mention that.
You could have easily had questions that take up more than one row. How
would somebody other than you know that? Apparently my question offended
you. For that, I apologize. Otto
"cy" wrote in message
...
you don't know what i mean?
let say i have 5q. in a row that is
A1(q.1),A2(q.2),A3(q.3),A4(q.4),A5(q.5)
how can i insert a column next to each q. so that the seqence now is
A1(q.1),A2(blank),A3(q.2)........
but some blank columns have already inserted,so how to write that VBA?

"Otto Moehrbach" ??:

You must mean rows instead of columns.
Yes, VBA can do that, but Excel needs to know how to identify a line as
being the beginning of a new question. Pretend that you are explaining
how
to do this to someone who doesn't know your data. What would you say to
him? HTH Otto
"cy" wrote in message
...
I have 500+ question in a row,how can I insert column in between every
questions but there are some questions already inserted with column,is
there
a method to save time so that each q. will have only 1 blank column in
between it?