How to Delete and Add columns in a spreadsheet

[yosi_lb]

Hi everybody

How can I delete column "B" for example and then add a new column after
column "F"/

thanks

 

[Frank]

Hi everybody

How can I delete column "B"

Right click Column head and choose Delete.

then add a new column after column "F"

Same method. Right click column head "F" and choose Insert.

thanks

Your welcome!

 

[yosi_lb]

sorry if I was missed understood

I need to delete and add column with visualbasic

thanks

 

[Dave Peterson]

Try recording a macro when you do it manually.

sorry if I was missed understood

I need to delete and add column with visualbasic

thanks