Posted to microsoft.public.excel.programming

Sal

external usenet poster

Posts: 84

Delete Columns

Sub DeleteColumns ( )

Range("K:K,M:M,P:P,S:S").Select
Selection.Delete Shift:=xlToLeft

End Sub

Is there a cleaner way to delete these columns than the code above?

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
create a macro to delete columns and then border remaining columns	Jane777	Excel Programming	1	July 18th 07 12:08 AM
merge text from 2 columns into 1 then delete the old 2 columns	sleepindogg	Excel Worksheet Functions	4	March 30th 06 07:25 PM
can't delete columns	Ed White	Excel Programming	6	March 8th 06 03:02 PM
Delete columns	Scottmk[_32_]	Excel Programming	8	September 3rd 04 01:11 AM
Delete Columns	Jean[_5_]	Excel Programming	1	March 5th 04 02:03 PM

All times are GMT +1. The time now is 02:01 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us