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?