Posted to microsoft.public.excel.programming

Lillian[_5_] Lillian[_5_] is offline

external usenet poster

Posts: 47

delete empty column in VBA

I have excel spreed sheet that I have some empty column
in between the columns, is anyway write the macro to do
that? also if all entire column has "0" and "NA", can I
deleted them all as well.

thanks.

Lillian

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Copy column header to next column, delete & delete every nth colum	genehunter	New Users to Excel	1	June 2nd 09 03:57 PM
delete cells column. Delete empty cells	myshak	Excel Worksheet Functions	0	March 9th 09 10:59 PM
Delete row with empty cell in column	Gene Augustin	Excel Discussion (Misc queries)	4	March 8th 09 08:03 AM
how to delete empty row in vba	Lillian[_3_]	Excel Programming	2	November 4th 03 12:59 AM
delete all EMPTY cells along each COLUMN	active_x[_5_]	Excel Programming	0	September 10th 03 03:41 AM

All times are GMT +1. The time now is 12:16 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us