If you didn't call Row as Column you would be more easily understood

For what you require, see Dave Peterson's answer in
http://www.excelforum.com/showthread.php?t=537047

--
cy Wrote:
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?





--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=537608