I want to delete the column B and column D in excel. But I dont want
that the cell to get shifted to left or right. i.e. after deleting the
column B and D, these columns should not get displayed in the excel
sheet at all.
Columns should be: Column A, Column C, Column E, Column F, Column G and
so on...

Thanks,
Reena


--
reena
------------------------------------------------------------------------
reena's Profile: http://www.excelforum.com/member.php...o&userid=30440
View this thread: http://www.excelforum.com/showthread...hreadid=512538

You cannot remove a column in excel, whatever you do it will be 256 columns
(excel 97 - 2003)
you can hide column B and column D but you can't make them disappear, if you
delete one another will take it's place

--
Regards,

Peo Sjoblom

Northwest Excel Solutions

Portland, Oregon




"reena" wrote in message
...

I want to delete the column B and column D in excel. But I dont want
that the cell to get shifted to left or right. i.e. after deleting the
column B and D, these columns should not get displayed in the excel
sheet at all.
Columns should be: Column A, Column C, Column E, Column F, Column G and
so on...

Thanks,
Reena


--
reena
------------------------------------------------------------------------
reena's Profile:
http://www.excelforum.com/member.php...o&userid=30440
View this thread: http://www.excelforum.com/showthread...hreadid=512538

Think this is not possible.
Why not just try hiding the cols B and D instead ?
It'll achieve your intents
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"reena" wrote in message
...

I want to delete the column B and column D in excel. But I dont want
that the cell to get shifted to left or right. i.e. after deleting the
column B and D, these columns should not get displayed in the excel
sheet at all.
Columns should be: Column A, Column C, Column E, Column F, Column G and
so on...

Thanks,
Reena


--
reena
------------------------------------------------------------------------
reena's Profile:
http://www.excelforum.com/member.php...o&userid=30440
View this thread: http://www.excelforum.com/showthread...hreadid=512538

Hi Reena,

Try hiding the columns:

Range("B1, D1").EntireColumn.Hidden = True

---
Regards,
Norman



"reena" wrote in message
...

I want to delete the column B and column D in excel. But I dont want
that the cell to get shifted to left or right. i.e. after deleting the
column B and D, these columns should not get displayed in the excel
sheet at all.
Columns should be: Column A, Column C, Column E, Column F, Column G and
so on...

Thanks,
Reena


--
reena
------------------------------------------------------------------------
reena's Profile:
http://www.excelforum.com/member.php...o&userid=30440
View this thread: http://www.excelforum.com/showthread...hreadid=512538

You may want to just empty the columns by selecting them and then hit
the "delete" key on your keyboard.

Hans