How to Delete and Add columns in a spreadsheet

Thread view:

Thread rating:

yosi_lb - 02 Jan 2007 20:31 GMT

Hi everybody

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

thanks

Frank - 02 Jan 2007 21:34 GMT

> 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 - 03 Jan 2007 04:43 GMT

sorry if I was missed understood

I need to delete and add column with visualbasic

thanks

>> Hi everybody
>>
[quoted text clipped - 8 lines]
>> thanks
> Your welcome!

Dave Peterson - 03 Jan 2007 15:12 GMT

Try recording a macro when you do it manually.

> sorry if I was missed understood
>
[quoted text clipped - 14 lines]
> >> thanks
> > Your welcome!

Signature

Dave Peterson