Add columns in Excel
I have an active Excel sheet with 10 columns. How do I add 20 blank columns after column 5?
I meant to add that "How do I add 20 blank columns after column 5 using applescript"?
3 replies
Hi,
Like this:
tell active sheet to set myRange to range ((get address of column 6) & ":" & (get address of column 25))
insert into rangemyRangeshiftshift to right -- insert 20 blank columns after column 5
------
Or this:
repeat 20 times -- insert 20 blank columns after column 5
insert into range (column 6 of active sheet) shiftshift to right
end repeat
Thanks. I had "insert into rangerange "F:F" shiftshift to right" 20 times but was looking for a more elegant way of achieving it. Your suggestion is great.
Add columns in Excel